Subject | Restore speed |
---|---|
Author | Kjell Rilbe |
Post date | 2010-10-14T03:20Z |
Hi,
To copy a database with a few million records in some tables we did a
backup and restore.
Backup took about 20 minutes, but restore took several hours, Most of
the time spent restoring indices.
Am I right in assuming the index DATA is not backed up, but only index
DEFINITIONS, so on restore every index has to be rebuilt?
If so is there any way I can do this faster another time?
FB 2.1 currently. Any difference in FB 2.5?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
To copy a database with a few million records in some tables we did a
backup and restore.
Backup took about 20 minutes, but restore took several hours, Most of
the time spent restoring indices.
Am I right in assuming the index DATA is not backed up, but only index
DEFINITIONS, so on restore every index has to be rebuilt?
If so is there any way I can do this faster another time?
FB 2.1 currently. Any difference in FB 2.5?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64