Subject Re: [ib-support] Re: Database Tuning (when to sweep and page size / buffers)
Author Ann W. Harrison
>Sean L. wrote;
> > ...
> >Yes, set your sweep interval to 0 and let your nightly GBAK perform
> >the sweep/garbage collection at that time.

At 08:24 PM 6/27/2001 +0200, Aage Johansen wrote:

>Should this be:
>1. Let gbak do the garbage collecting
>2. Let sweep reset OldestTransaction
>or will gbak do-it-all?

Run the gbak. It will garbage collect. Then run sweep,
which will be (relatively) fast since there's no trash
to collect. Gbak doesn't set the OIT.


Regards,

Ann
www.ibphoenix.com
We have answers.