Subject Re: [firebird-support] Sweep Interval
Author Rohit Gupta
Thomas,

opinion is divided here. I have seen three explanations now NT-OIT,
NT-OAT and OAT-OIT. I dont know who to believe anymore. :-)


Thomas Steinmaurer wrote:

>Hi,
>
>
>
>>Sweep interval sets the threshold for the engine to perform a sweep. If it
>>is 20000 (the default) it says "Don't perform any sweep until the
>>difference between the oldest interesting transaction and the newest
>>transaction is 20000 or more".
>>
>>
>
>AFAIK next transaction has nothing to do with the sweep interval,
>that means if OAT-OIT >= sweep interval, then the sweep kicks in.
>
>Or am I completely wrong here?
>
>
>
>