Subject | RE: [firebird-support] Re: One table taking a long time to insert/update |
---|---|
Author | Leyne, Sean |
Post date | 2008-06-26T00:48:55Z |
Robert,
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
> Database header page information:...
> Oldest transaction 4391647The fact that there is a large difference between the "Oldest active"
> Oldest active 4391648
> Oldest snapshot 4390774
> Next transaction 4526929
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