> > I would also ask
> > how is the sweep interval calculated.
> >
>
> It defaults to 20000 transactions, but it is set in your database. You
> can set it to whatever value you like. I can't tell you what is so
> magical about 20000 though. It can also be turned off (set to 0) so it
> never runs. This can be useful if you have a nightly downtime or at
> least an off peak time. You can use the task scheduler of your OS to
> call sweep during this time.
>
> Adam
>

and to add to Adam's info, it is calculated by subtracting the oldest active
transaction from the Next transaction.
Many applications never cause this gap to get anywhere near 20,000. My apps
never do. Some desings can't avoid this possibility.
The old BDE apps, where everything was set to server autocommit, the sweepe
was never fired.
The documents, over the years, has been confused as to how the gap is
calculated. I won't be surprised if someone correct me.
Alan