| Subject | Re: [firebird-support] BLOB |
|---|---|
| Author | Ivan Arabadzhiev |
| Post date | 2014-10-13T13:59:40Z |
fbsvcmgr remotehost:service_mgr -user sysdba -password XXX action_backup -dbname some.fdb -bkp_file stdout >some.fbk
> <Are you running gbak from your local client machine against a remote
> <server/database and creating the backup file on your local machine? I If
> <so, this is not a good idea from a performance perspective.
>
> I run the backup automatically each night (Windows scheduled tasks), for
> a few of my customers, via the Internet.
Ok, even worse.
> And yes, I need the backup file locally, on my system.
>
> As I mentioned before, if the backup lasts for 10 minutes of which
> log_tables takes 9 , no problem at all, FireBird works like a charm for
> me (with Delphi XE5), I was just asking why this huge difference between
> backing up tables with or without BLOB tables.
Can you please try my previously posted gbak call, because this will
force to run everything on the remote machine. Just to get an idea on
how much this is faster.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.