Subject Re: [firebird-support] how to find the bottleneck or slow queries/triggers/stored procedures
Author mailstor
Hello Andi,

> Oldest transaction 27036789
> Oldest active 27036790
> Oldest snapshot 27036790
> Next transaction 27036791

> Creation date Jan 18, 2007 18:11:29
> Attributes force write


Your database is running for 18+ months and has piled up 27 million
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.