Sweep is Garbage Collection.
We use transaction tables that regularly get emptied.
Helen Borrie does the same thing.
Thus we need to sweep but we don't want it to take over
the full CPU.

Regards,

Robert.

--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Can Firebird run sweeping without taking 100% CPU.
> > Interbase 6 certainly uses 100% CPU.
> > Our clients cannot have this occur at any time.
> >
> > Regards,
> >
> > Robert.
> >
>
> You don't really need to sweep if it's not required. Just don't

stall your

> transactions and leave the sweep set to 0 (manual). Then you can do

your

> house keeping at your own timing.
> Alan