Subject | Re: [firebird-support] how to find the bottleneck or slow queries/triggers/stored procedures |
---|---|
Author | mailstor |
Post date | 2008-08-18T08:56:51Z |
Hello Andi,
transaction corpses without ever having been backed-up/restored. While
I can not say for certain that this will help much in your actual
situation, it is surely worth trying to do a backup/restore.
Ann Harrison has - not too long ago - in this forum described how long
gone transactions still hold space in the database.
> Oldest transaction 27036789Your database is running for 18+ months and has piled up 27 million
> Oldest active 27036790
> Oldest snapshot 27036790
> Next transaction 27036791
> Creation date Jan 18, 2007 18:11:29
> Attributes force write
transaction corpses without ever having been backed-up/restored. While
I can not say for certain that this will help much in your actual
situation, it is surely worth trying to do a backup/restore.
Ann Harrison has - not too long ago - in this forum described how long
gone transactions still hold space in the database.