Re: Overcoming 7.12 vs. 5.05 performance gap

Posted in 1997

Neil Truby — Tue, 07 Jan 1997 19:00:01 +0000 — source: Informix-list mailing list archive (1991-1998)

>> BUFFERS 2000 << This seems very small indeed. How much physical memory do you have? If you have 256M, then a BUFFERS value of up to 50,000 should be OK. About 20-25% of physical memory is the usual starting point. if you do increase BUFFERS substantially, you should consider corresponding changes to LRU_MIN_DIRTY and LRU_MAX_DIRTY. How many processors does your box actually have? Neil Truby Chase Bank, Bournemouth, UK