Subject | backup speed champion |
---|---|
Author | Mario |
Post date | 2005-07-17T07:01:32Z |
I run backup of a small test database (2 MB) from IBConsole (IB v.6.5).
The database has only small amount of records, most of them
automatically imported from a different database system. Only very few
records were edited/deleted.
The backup parameters were left as defaults, i.e. as provided by
IBConsole:
Format Transportable, Metadata only false, Garbage collection true,
Transactions in Limbo process, Cheksums process, Convert to tables
false, Verbose output to screen; I left the file size blank.
The backup took an outrageous 41 minutes to complete (on a fast
computer) !
I replicated this on several other small databases backed up the same
way. Most of the backup time was spent "writing domain RDB$xxx".
What's wrong with this backup ?
I then run restore of the backed database, also form IBConsole (it
only took a couple of seconds to complete) and backed the restored
database again. This time the backup took only a few seconds.
Is there anything I can do or (un)check prior to the backup to solve
this unacceptable speed?
Thanks & regards.
Mario
The database has only small amount of records, most of them
automatically imported from a different database system. Only very few
records were edited/deleted.
The backup parameters were left as defaults, i.e. as provided by
IBConsole:
Format Transportable, Metadata only false, Garbage collection true,
Transactions in Limbo process, Cheksums process, Convert to tables
false, Verbose output to screen; I left the file size blank.
The backup took an outrageous 41 minutes to complete (on a fast
computer) !
I replicated this on several other small databases backed up the same
way. Most of the backup time was spent "writing domain RDB$xxx".
What's wrong with this backup ?
I then run restore of the backed database, also form IBConsole (it
only took a couple of seconds to complete) and backed the restored
database again. This time the backup took only a few seconds.
Is there anything I can do or (un)check prior to the backup to solve
this unacceptable speed?
Thanks & regards.
Mario