Subject Re: [firebird-support] gbak slow on remote connection fas on local
Author Alexandre Benson Smith
Carlos H. Cantu (TeamFB) wrote:

>Ok, just to add something more to this backup talk...
>
>When I run a backup using the services API from a Delphi application
>over internet (IBX or IBOAdmin components, or even using IBExpert) on
>a remote server, ADSL connection, it takes more than 30 minutes to
>finish (very small DB - 10MB). Verbose if off - FB 1.5.2 SS on Linux.
>
>If I do the same using gfix with the -SE option, it takes less than
>one minute.
>
>I would like to know why, since in both cases the service API is being
>used and so the time should be almost the same.
>
>Carlos
>http://www.warmboot.com.br
>FireBase - http://www.FireBase.com.br
>
>
Hi Carlos,

I think we have diferent scenarios here

-SE means to use the services API what lead the backup to be done on the
server side, without -SE gbak behaves like a normal client program that
reads data from the conection (in this case the ADSL) what will be slow.
This is how I understand -SE, maybe it's not correctly.

I hav enever used -SE since I do the backups in cron jobs direct on the
server or when I am on the same local lan to my locla HD and it has
never been slow (at least I have never noticed it).

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br