Subject Re: [firebird-support] Re: Firebird Usage Load Problem
Author Milan Babuskov
Ann W. Harrison 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.

You're right. I noticed that few days after I sent this message, so I
didn't bother to correct myself.

--
Milan Babuskov
http://fbexport.sourceforge.net