Re: RA_PAGES and RA_THRESHOLD Defaults

This is a multi-part message in MIME format. --------------A44C74DFA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit mailgw!hpx400!Trevisol_Roberto/bbb_cak@srv3-poa.nutecnet.com.br wrote: > > 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! It is a bunch of hooey. We use an actual i/o size of around 64K (platform dependent), but that has no effect on what you can set your read ahead to be. For a readahead > 64K, we would just do multiple i/o's to fill the RA buffer. You can set it as high as you want, though the level of benefit as a result is going to vary greatly based on the nature of your applications. -- Dave Kosenko, Informix Professional Services **************************************************************************** While it is true that there is more than one way to skin a cat, the cat himself generally fails to appreciate the differences. --------------A44C74DFA Content-Type: text/plain; charset=us-ascii; name="Ifxdiscl.txt" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="Ifxdiscl.txt" ************************************************************************* Note: please do not send me email asking about features, or asking about Informix problems and how to solve them. I answer what questions I can in this forum (comp.databases.informix) when I have the time to spare. For questions on features, call your local sales rep or check out the Informix web site (http://www.informix.com). For technical problems, call Informix tech support. ************************************************************************* Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. --------------A44C74DFA--