Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Apostolos Varnas — — source: Informix-list mailing list archive (1991-1998)
Stuart Cracraft wrote:
>
>
> So far, setting LRU_MIN_DIRTY and LRU_MAX_DIRTY down to
> 5 and 7 respectively, with CLEANERS at 29 and LRU
> at 5 (LRU formerlyl at 16) has resulted in approximately 1/5th the
> checkpoint durations of when CLEANERS was at 29 and LRU was at 16
> and LRU_MIN_DIRTY was at 55 and LRU_MAX_DIRTY was at 60. But I'd
> like to get it down another factor of 2. Right now, my checkpoint
> durations are at 5-10 seconds which is just at the outside limit of
> tolerable interactive response in a GUI. It really isn't responsive.
>
>
Stuart
have you tried to reduce LRU_MIN_DIRTY to a value less than 5.This will leave
less work to be done for the checkpoints.
Regards
Tolis
+---------------------------------------------------------------------+
| V+K Relational Solutions email: tvarnas@compulink.gr |
| Deligiorgi 26 tvarnas@orbit.de |
| 546 42 Thessaloniki Voice: (30) 31 820270 |
| Greece Fax: (30) 31 865463 |
+---------------------------------------------------------------------+
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.