Re: In Memory Tables

David McPaul wrote: > 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. You can make a table or index MEMORY RESIDENT. That means that pages for the table or index are given a higher priority and tend to stay in the buffer cache. Of course, this is only useful for smaller tables that are used by performance critical applications. It is especially useful for tables and indexes that don't get accessed often enough to keep them in the buffer pool. > Is this something a later version of informix supports? I'm pretty sure you have this feature in 7.31, although I'm not that familiar with the NT port. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+