Re: Caching tables in shared memory

Uh, Rav... That's what BUFFERS are for. Ask your DBA about this parameter. The system is designed to do it as best it can within limits of memory configured. Caching caches only works if you have a faster storage medium. You don't. BUFFERS is as good as it gets. Forget trying to outdo the caching algorithm, it's not worthwhile. Between BUFFERS and RAPAGES and RATHRESHOLD (ask DBA about them too...), it's tough to outdo the system facilities. Greg ravi@in.dhl.com wrote: > > Hi Gurus, > > Here are a few questions regarding caching of frequently accessed table > in shared memory. During a recent setup , I found that in my code a few > of the tables were accessed very frequently. These are master tables and > this particular module need not do any updates on these tables. Also , > the data in these tables in static. > > 1. Would caching the data help in improving performance ? Would Informix > caching be enough ? Is it better to read the data in global array and > then go on with life ? > > 2. Has anybody tried this ? If yes, then how successful has the venture > been ? > > 3. Can I specify somewhere in the Informix setup what tables to cache ? > Can it be a wishlist item ;-) > > Thanks in advance for any suggestions/tips etc. > Ravi.... > > -------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet