Subject Re: [firebird-support] Re: Poor Performance
Author Ann W. Harrison
berniebialt wrote:
> So you would suggest taken the system offline and running a sweep
> on a nightly basis?
>

You can run sweep on-line, no problem. At one point in my frequently
befuddled past, I thought that an on-line sweep couldn't update the
value kept in the header page for the oldest interesting transaction,
but I was wrong. Sweep is completely OK on-line, except for the cycles
it uses.

Regards,


Ann