Subject | Re[2]: [firebird-support] gbak speed |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-04-11T10:53:07Z |
Hello, André!
Thursday, April 11, 2013, 2:42:01 PM, you wrote:
AK> My biggest database is 1/74 of the size of yours.
AK> I need ~5 Minutes to backup a freshly restored database, backup takes
AK> longer if the restore is longer ago (up to 6.5 minutes).
too slow. at my old desktop with Athlon 64 x2 5200 and 3 SATA II drives
backup of 2.7GB database from one drive to another took from 3.5 to 5
minutes, depending on protocol used.
The fastest way to do backup is to use Services API,
i.e. -se option of gbak. And, to use -g option of course.
So, with worst 5 minutes result, 74/2.7 = 2 hours and 17 minutes.
And, with the a bit modern hardware (but still desktop with several
drives)
restore of another database, 1.5GB backup size and 3.9gb
resulting database also takes not more than 5 minutes,
via -se.
But, via localhost - around 1 hour.
--
Dmitry Kuzmenko, www.ib-aid.com
Thursday, April 11, 2013, 2:42:01 PM, you wrote:
>> How does this compare with the experience of others?AK> Hmmm. A quick calculation shows:
AK> My biggest database is 1/74 of the size of yours.
AK> I need ~5 Minutes to backup a freshly restored database, backup takes
AK> longer if the restore is longer ago (up to 6.5 minutes).
too slow. at my old desktop with Athlon 64 x2 5200 and 3 SATA II drives
backup of 2.7GB database from one drive to another took from 3.5 to 5
minutes, depending on protocol used.
The fastest way to do backup is to use Services API,
i.e. -se option of gbak. And, to use -g option of course.
So, with worst 5 minutes result, 74/2.7 = 2 hours and 17 minutes.
And, with the a bit modern hardware (but still desktop with several
drives)
restore of another database, 1.5GB backup size and 3.9gb
resulting database also takes not more than 5 minutes,
via -se.
But, via localhost - around 1 hour.
--
Dmitry Kuzmenko, www.ib-aid.com