Subject | [firebird-support] Gbak backup/restore loss of performance |
---|---|
Author | dominique.barrieu |
Post date | 2005-07-21T12:22:29Z |
hi,
We want to use gbak to save and restore a data base.
We carry out the following procedure:
- Run script of creation of the data base with primary key, foreign key
and index
- Run data insertion script
- Run a querry with isql. The stat gives a time of 0.16s
- Run the backup procedure with gbak with options: - B - v (not
detected problems)
- Run restore procedure with gbak with options: - C - v (not detected
problems)
- Run same querry with isql. The stats gives a time of 0.90s
the orriginal firebird.conf used.
Version of firebird: 1.5.2.4731.
Super server used as service.
Data base is local.
why I have a loss of performance ?
PS: after restore the data base is 10% smaller than orrigine...
We want to use gbak to save and restore a data base.
We carry out the following procedure:
- Run script of creation of the data base with primary key, foreign key
and index
- Run data insertion script
- Run a querry with isql. The stat gives a time of 0.16s
- Run the backup procedure with gbak with options: - B - v (not
detected problems)
- Run restore procedure with gbak with options: - C - v (not detected
problems)
- Run same querry with isql. The stats gives a time of 0.90s
the orriginal firebird.conf used.
Version of firebird: 1.5.2.4731.
Super server used as service.
Data base is local.
why I have a loss of performance ?
PS: after restore the data base is 10% smaller than orrigine...