Re: Read ahead

Posted in 1998

LeeKB — Mon, 16 Mar 1998 16:23:21 +0800 — source: Informix-list mailing list archive (1991-1998)

Jay, For OLTP environment, set ra_pages to the lesser value - ie. not to do too much Read Ahead. Again, exact value depends on the nature of your apps. Good Luck LeeKB Jay Aymond wrote: > > Any recomendations on what percentage of buffers should be used for "ra_pages" > and "ra_threshhold" in a system that is mostly OLTP and batch processing? > > ___________________________________________________________ > Jay Aymond > United Life & Annuity Insurance Company > > Email: jay@ulife.com