Subject | Re: [firebird-support] gbak slow on remote connection fas on local |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-11-22T21:37:14Z |
Alexandre Benson Smith wrote:
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"
192.168.1.1:odin 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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
>I can understand that "localhost" tend to be a bit faster than a realJust to inform with precise numbers
>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)
>
>
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"
192.168.1.1:odin 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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br