Subject | Re: [firebird-support] Sweep Interval |
---|---|
Author | Rohit Gupta |
Post date | 2004-01-12T10:08:49Z |
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:
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?
>
>
>
>