Subject Re: [firebird-support] gbak slow on remote connection fas on local
Author Alexandre Benson Smith
Alexandre Benson Smith wrote:

>I can understand that "localhost" tend to be a bit faster than a real
>TCP/IP conection since it don't go trought the wire, just the loopback
>interface, but I am experiencing a 10 seconds back-up using "localhost"
>and a more than 30 minutes (stopped it because I can't believe it's so
>slow) on the remote machine, the lan has low traffic, the server is
>almost idle (below 2% CPU utilization)
Just to inform with precise numbers

I just measure the time precisely now

gbak runs for 21 minutes and 36 seconds to back-up an 11MB database and
generate a 3.6MB transportable backup.
on the client machine:
C:\localpub2\bd\odin>"\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" odin_2005_11_22.fbk -user sysdba -password masterkey -v
-t -g

on the server machine:
[root@server root]# time /usr/local/firebird/bin/gbak localhost:odin
odin_2005_11_22.fbk -user sysdba -password masterkey -v -t
gbak: closing file, committing, and finishing. 3692032 bytes written

real 0m9.966s
user 0m0.650s
sys 0m0.360s

see you !

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