Subject Re: [firebird-support] Re: Our firebird database performance has come to a halt
Author Alexandre Benson Smith
dreezl wrote:

>>What about the network connection between the two servers? What is
>>the connection speed between them? How many concurrent connections(on
>>average) are being made to Firebird?
>The servers are connected through a SonicWall firewall / VPN running
>at 100mb. We tried chaning the ports the cables were plugged in, but
>that didn't help. When we moved the firebird backup file from the one
>server to the other it moved over very quickly, so I don't think that
>is the problem. I will do more looking into it though, just in case.
>During the slow times the concurrent connections were usually around
>170 - 180, now it is 19. By the way, is there an easy way to find that
>information. The ways I checked seemed very cumbersome.
>Thanks for the input.
Some weeks ago I faced a strong slow on performing back-ups on my local
lan, copying files using samba was fast and normal, but back-ups are
10-20 times slower than running against a local database.

Nigel Weeks show me a tip that solved the issue:
On the network configuration dialog turn off the auto-negotiating speed
and set it up manually (take attention to the Full/Half duple point).
Try playing with the settings and see how performs better for you, the
problem in may case was that Windows Auto-negotiation choosed
100mpbs/Full Duplex, when I set it to Half duplex the speed comes back
to normal.

This solved my problem. Don't know if it can help you too.

Don't know why it was fast before and now it is slow, but I never had
noticed that a remote back-up was slow on my lan, so I assume it start
to be slow at some time without some aparent reason.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil