Subject Re: [firebird-support] Re: Firebird Usage Load Problem
Author Ann W. Harrison
Milan Babuskov wrote:
> Maurice Ling wrote:
>
>> Oldest active 1569536
>> Next transaction 1584914
>> Sweep interval: 20000
>
>
> This should tell almost everything. AFAIK, you are reaching a gap of
> 20000 records and probably the sweep kicks in, and keeps running in
> background even when Python does not query anything.

No. Sweep is the difference between the oldest interesting and the
oldest active. The value of the next transaction is irrelevant to sweeping.


Regards,


Ann