Subject Re: [firebird-support] Still About performance and running slow
Author Douglas Tosi
On Fri, Apr 24, 2009 at 5:22 PM, Leyne, Sean <Sean@...> wrote:
>> Oldest transaction 434
>> Oldest active 8366
>> Oldest snapshot 8366
>
> You have a database transaction that is not committing!

The difference between Oldest Transaction and Oldest Active is the
number o transactions that need sweeping.
When transactions are left uncommited, it's the difference between
Oldest Active and Next that increases.

hth,
--
Douglas Tosi
www.sinatica.com