Subject | Re: Database Tuning (when to sweep and page size / buffers) |
---|---|
Author | Aage Johansen |
Post date | 2001-06-27T18:24:03Z |
Sean L. wrote;
What is of importance, and how?
1. Let gbak do the garbage collecting
2. Let sweep reset OldestTransaction
or will gbak do-it-all?
Regards,
Aage J.
>...Could you expand on the specific "server disk configuration" subject ?
>.... The larger page size can also improve
>raw database performance, but this also depends on a number of
>factors including your server disk configuration.
What is of importance, and how?
> ...Should this be:
>Yes, set your sweep interval to 0 and let your nightly GBAK perform
>the sweep/garbage collection at that time.
1. Let gbak do the garbage collecting
2. Let sweep reset OldestTransaction
or will gbak do-it-all?
Regards,
Aage J.