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

>Hi Alexandre,
>Alexandre Benson Smith wrote:
>>Hi people !
>>I have a doubt
>>Client FB 1.5.2 on WinXP
>>Server FB 1.5.2 SS on Linux Redhat 9
>>Both on the same lan segment (100Mbps/sec)
>>if I run a gbak from the client machine it runs VERY slow
>>gbak server:alias alias.fbk -user sysdba -password masterkey -v -t
>>I leave it running for 30 minutes and it not finishes, it has progress
>>along the tables but extremely slow !
>>If I run the same on the server machine
>>gbak localhost:alias alias.fbk -user sysdba -password masterkey -v -t
>>it runs in less than 10 seconds
>Yes, I noticed the same thing. In my case, I worked around it by
>automating a telnet onto the server, running the gbak through telnet,
>compressing to a tgz and copying the file over again by FTP. Rather
>tedious, but incredibly faster.
Hi Jonathan !

Oh yes.. I did the same (using ssh instead :-P ) but I'd like to know why !

I have never noticed it, I think it's quite impossible that I never
didn't noticed that it is so slow if it's the normal behaviour since I
am always on clients and doing production databases backup's to my
machine for some tests

Some more info:
I have tried it from another XP machine, the same happens, I tried to
backup another DB around 100MB I got he same behaviour some tables goes
fast some others a bit slow (around 40k records) and others that are
smaller appears to be even slow. :-(

It's not something critical to me, I just whant to know what happens. :-/

Really don't know what is happening here...

thank you !

see you !

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