Re: RA_PAGES and RA_THRESHOLD Defaults

Recently, I heard from Informix Tech Support that you can not set RA-PAGES higher than 32, because that's the Informix limit for I/O length. Does anyone else have that information? By now I have it as true! Roberto Trevisol rtrevisol@bamerindus.com.br }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 } }