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.
>FireBase -
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil