Re: RA_PAGES and RA_THRESHOLD Defaults

Posted in 1996

Greg — Thu, 04 Jul 1996 22:34:16 -0500 — source: Informix-list mailing list archive (1991-1998)

John - I think they are RA_PAGES=4 and RA_THRESHOLD=2. I have found in our environment, which is heavy read and not so much write that these are very low. I have them set to 64 and 32 respectively, and am contemplating increasing them (I use 99.99...% of those I read ahead). It all depends on how you tend to reference pages.... good luck - greg John Morton wrote: > > Does anybody have any idea what the defaults are for RA_PAGES and > RQ_THRESHOLD in 7.1? I'm not getting good read ahead numbers right > now, but I don't want to adjust these two parms until I know where I'm > starting from. > > Thanks! > Regards, > > John Morton > > Toronto, Ontario, Canada > mortonj@interlog.com > (416)288-4855