Subject | RE: [firebird-support] slower backup after upgrade from classic to superserver |
---|---|
Author | Alan McDonald |
Post date | 2006-01-22T22:37:12Z |
> Hello,let's do a reality check as well. Let's suppose for a minute we get this
>
> I have the problem, that the backup time is grown up very high after
> the upgrade from the classicserver (1.0) to the superserver (1.5).
> With the classicserver gbak makes the backup for a 5 GB database in 30
> to 40 minutes. After the upgrade the same backup needs more then 3 hours.
> An other 19 GB database needs more then 8 houres.
> The restore ist very slow too and this is my greatest problem. The
> databases are used in medical environments and more then 3 or 8 hours
> for a restore is a very long time.
>
> Thanks for your help
>
> Erich
time down to 40 minutes again.
How often are you restoring such that the restore is the file your users are
then using instead of the original?
I see no need for a restore cycle back to a restored file on a regular
basis.
Do regular backups with garbage collection.
Do regular restores to a test file to check data integrity and validate the
backup.
Do very infrequent cycles where the users must wait for the restored file.
Alan