| Subject | Re: [firebird-support] gbak of firebird2.13 is much slower than firebird1.5 |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-06-08T15:00:06Z |
flyingfb wrote:
If you're not using the -g switch on the backup, you should. There's
no reason to clean up old versions of records in a database you're
going to replace.
Most installations rarely do a full backup/restore. A nightly backup
or sweep and backup releases space for reuse at much lower cost. If
you think your indexes are causing problems as they age, you could just
rebuild some of them each night rather than doing a full restore of
the database.
Cheers,
Ann
> our database has 1641 tables,290 views,52 procedures,292 triggers,187 generators,3500 indices. file size is 40GB.our database. this is a big problem for us.
> we have used firebird1.5 for six years and when we upgrade to firebird2.13 this year, we can not finished
> the backup and restore our database at the night to cleanup and speedup
> can some one help us? need we return back to firebird1.5?OK, here are a two suggestions to start with.
>
If you're not using the -g switch on the backup, you should. There's
no reason to clean up old versions of records in a database you're
going to replace.
Most installations rarely do a full backup/restore. A nightly backup
or sweep and backup releases space for reuse at much lower cost. If
you think your indexes are causing problems as they age, you could just
rebuild some of them each night rather than doing a full restore of
the database.
Cheers,
Ann