Subject | 3rd party tools backup much faster than gbak!? |
---|---|
Author | F1n4rf1n |
Post date | 2006-03-01T11:28:29Z |
Hi!
We experienced a strange behaviour:
calling gbak via cron or commandline our backup of a 35 gigabyte database
lasts around 4 hours. During this time we neither see cpu load nor heavy I/O
load on the server.
If we use IBExpert, Flamerobin, IBConsole or any other tool to start the
backup job it is completed after less then 45 minutes! (Only limited by I/O
capacity of the server).
We tested with 2 gentoo servers - 1 with NTPL enabled, 1 without and using
the firebird ebuild.
Same results with ubuntu and 1.5.1 apt-package.
With Firebird 1.5.3 running on a Windows XP workstation the results are
similar but not this extreme..
I couldn't find anything in Helen's Book (p.813ff) regarding this and google
wasn't that helpful either.
Maybe someone here knows why a local gbak is so slow and if there is a
possibility to speed up the backup process?
Kind regards,
Ralf ter Veer
--
Bis zu 70% Ihrer Onlinekosten sparen: GMX SmartSurfer!
Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer
We experienced a strange behaviour:
calling gbak via cron or commandline our backup of a 35 gigabyte database
lasts around 4 hours. During this time we neither see cpu load nor heavy I/O
load on the server.
If we use IBExpert, Flamerobin, IBConsole or any other tool to start the
backup job it is completed after less then 45 minutes! (Only limited by I/O
capacity of the server).
We tested with 2 gentoo servers - 1 with NTPL enabled, 1 without and using
the firebird ebuild.
Same results with ubuntu and 1.5.1 apt-package.
With Firebird 1.5.3 running on a Windows XP workstation the results are
similar but not this extreme..
I couldn't find anything in Helen's Book (p.813ff) regarding this and google
wasn't that helpful either.
Maybe someone here knows why a local gbak is so slow and if there is a
possibility to speed up the backup process?
Kind regards,
Ralf ter Veer
--
Bis zu 70% Ihrer Onlinekosten sparen: GMX SmartSurfer!
Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer