Subject Re: [firebird-support] gbak slow on remote connection fas on local
Author Carlos H. Cantu (TeamFB)
Yep, I know my problem is not the same as yours. I just wanted to
extend the talk and add some strange behavior that I faced with
backup through services...

Carlos
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br

ABS> 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
>>
>>
ABS> Hi Carlos,

ABS> I think we have diferent scenarios here

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

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

ABS> see you !