In Memory Tables

Hello, Does Informix 7.31 TC5 support In Memory Tables where a specific table can be preloaded into memory. My current thought is we do not need it as most used tables will eventually be cached by the informix engine anyway. ie we increase our buffers and we will hold more tables in memory anyway. Is this something a later version of informix supports? David McPaul Senior Analyst Programmer -------------------------------------------------------- Lumley Technology ABN 20 000 017 194 Level 8, 55 Sussex Street Sydney, NSW 2000 Australia Ph: 02 9248 1356 Fax: 02 9248 1333 email: dmcpaul@NO_SPAM_lumley.com.au This e-mail is intended for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify us immediately at helpdesk@lumley.com.au and destroy the original message. While this mail and any attachments have been scanned for common computer viruses and found to be virus free, we recommend you also perform your own virus checking processes before opening any attachments.

I think 7.30 supports it. SET TABLE tab_name/index_name MEMORY_RESIDENT/NON_RESIDENT. Prashant David McPaul <dmcpaul@lumley.com.au> wrote in message news:<baejr1$qp1$1@terabinaries.xmission.com>... > Hello, > > Does Informix 7.31 TC5 support In Memory Tables where a specific > table can be preloaded into memory. > > My current thought is we do not need it as most used tables will > eventually be cached by the informix engine anyway. ie we increase our > buffers and we will hold more tables in memory anyway. > > Is this something a later version of informix supports? > > David McPaul > Senior Analyst Programmer > -------------------------------------------------------- > Lumley Technology > ABN 20 000 017 194 > Level 8, 55 Sussex Street > Sydney, NSW 2000 Australia > Ph: 02 9248 1356 > Fax: 02 9248 1333 > email: dmcpaul@NO_SPAM_lumley.com.au > > This e-mail is intended for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify us immediately at helpdesk@lumley.com.au and destroy the original message. While this mail and any attachments have been scanned for common computer viruses and found to be virus free, we recommend you also perform your own virus checking processes before opening any attachments.