Loading into Shared Memory...
Hi, Can i explicitly ask Informix to load a table into Shared-Memory? And then later on sync the copy of table on disk \\ with the one in shared memory? Any suggetions welcome Thanks Anand Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.
Marshall Turner wrote: Well, there is the SET RESIDENCY feature in version 7.3 -- the syntax is something like --- SET TABLE tab_name MEMORY_RESIDENT The table will remain in the buffer cache as long as possible. Writing the table out happens normally via checkpoints/LRU writes. > > No, you don't have explicit control over what is in the shared memory > buffers. Informix manages the buffers based on a 'least recently used' > (LRU) scheme that keeps in memory data it expects to be used again and > flushes what is not. > > Marshall > > <anandpa@my-deja.com> wrote in message news:7pcd48$fe7$1@nnrp1.deja.com... > > Hi, > > > > Can i explicitly ask Informix to load > > a table into Shared-Memory? > > And then later on sync the copy of table on disk \\ > > with the one in shared memory? > > > > Any suggetions welcome > > Thanks > > Anand > > > > > > Sent via Deja.com http://www.deja.com/ > > Share what you know. Learn what you don't.
No, you don't have explicit control over what is in the shared memory buffers. Informix manages the buffers based on a 'least recently used' (LRU) scheme that keeps in memory data it expects to be used again and flushes what is not. Marshall <anandpa@my-deja.com> wrote in message news:7pcd48$fe7$1@nnrp1.deja.com... > Hi, > > Can i explicitly ask Informix to load > a table into Shared-Memory? > And then later on sync the copy of table on disk \\ > with the one in shared memory? > > Any suggetions welcome > Thanks > Anand > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.
Starting with 7.3+, the syntax is: SET TABLE <tablename> MEMORY_RESIDENT Please remember that if you want this table in memory ALL the time, you will need to remember to re-execute the syntax each time you recycle the instance. Take care. =============================================== Clifton M. Bean cmbean@msn.com SAP/Informix Database Administrator Informix Certified Database Specialist Informix 4GL-Certified Informix D4GL-Certified Tekmetrics Certified Informix DBA Tekmetrics Certified RDBMS Developer =============================================== <anandpa@my-deja.com> wrote in message news:7pcd48$fe7$1@nnrp1.deja.com... > Hi, > > Can i explicitly ask Informix to load > a table into Shared-Memory? > And then later on sync the copy of table on disk \\ > with the one in shared memory? > > Any suggetions welcome > Thanks > Anand > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.