What's the impact if CLEANERS >= LRUS ?

Posted in 2000

Wu — Wed, 17 May 2000 16:56:58 +0800 — source: Informix-list mailing list archive (1991-1998)

As he subject says. thanx

↪ replying to Wu

QueriX 4GL / Mehdi — Wed, 17 May 2000 12:40:40 +0100 — source: Informix-list mailing list archive (1991-1998)

Wu wrote: > As he subject says. > > thanx CLEANERS fighting over LRUS ? :-) -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) ESQL/C Compiler For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------

↪ replying to Wu

Art S. Kagel — Fri, 19 May 2000 12:16:25 -0400 — source: Informix-list mailing list archive (1991-1998)

CLEANERS should be >= LRUS. The impact is that your checkpoints will be shorter and LRU flushes between checkpoints will be smoother and have less impact on running queries. The downside whenever you shift I/O from the checkpoints towards LRU writes is possibly increasing the impact the engine has on non-database processes running on the machine. Art S. Kagel Wu wrote: > > As he subject says. > > thanx