Subject RE: [firebird-support] Re: One table taking a long time to insert/update
Author Leyne, Sean
Robert,

> Database header page information:
...
> Oldest transaction 4391647
> Oldest active 4391648
> Oldest snapshot 4390774
> Next transaction 4526929

The fact that there is a large difference between the "Oldest active"
and "Next transaction" value is a sign that you have a 'stuck' database
connection/transaction.

This active is preventing the engine from performing normal record
version cleanup operations.

A growing number of versions of records can slow down the system as the
engine must 'wade' through the older versions to determine correct state
of each record to be processed/queried.

You need to track down this 'offending' connection/transaction.


Sean