RE: In Memory Tables
Ah ok, I was looking at the ALTER TABLE definition. Thanks David McPaul > -----Original Message----- > From: pk26au@yahoo.com [mailto:pk26au@yahoo.com] > Sent: Wednesday, May 21, 2003 2:56 PM > To: informix-list@iiug.org > Subject: Re: In Memory Tables > > > 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. > 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.