Subject | Re: [ib-support] Re: Database Tuning (when to sweep and page size / buffers) |
---|---|
Author | Ann W. Harrison |
Post date | 2001-06-27T21:36:07Z |
>Sean L. wrote;At 08:24 PM 6/27/2001 +0200, Aage Johansen wrote:
> > ...
> >Yes, set your sweep interval to 0 and let your nightly GBAK perform
> >the sweep/garbage collection at that time.
>Should this be:Run the gbak. It will garbage collect. Then run sweep,
>1. Let gbak do the garbage collecting
>2. Let sweep reset OldestTransaction
>or will gbak do-it-all?
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.