| Subject | RE: [firebird-support] Re: Can stopping the Firebird Server damage database if a sweep is being performed - Email found in subject |
|---|---|
| Author | Leyne, Sean |
| Post date | 2010-05-14T20:43:13Z |
> > Vlad,Perhaps it is a 'language' issue but ...
> >
> > > > All applications, well behaved or not, will run into the 20,000
> > > *interval* as this is the number of transactions since the last
> sweep.
> > >
> > > Think twice on it, please ;)
> >
> > I did. What did I get wrong?
>
> Sweep interval is not a "number of transactions since the last
> sweep".
The IB 5.5 documentation describes a sweep being triggered when:
"... the difference between the OIT and the newest transaction reaches the threshold."
So, in the case of a SuperServer install, where garbage collection is turned off, the above definition will be true when the number of transactions since the last sweep reaches the threshold.
Sean