Loading into Shared Memory...
A poster asked whether Informix can be told to load a table into shared memory and later sync it with the disk copy. Marshall Turner said buffer contents are managed by LRU with no explicit control. J. Dority and Clifton M. Bean pointed to SET TABLE tabname MEMORY_RESIDENT in 7.3+, which must be re-executed after each instance restart.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.