RE: Loading into Shared Memory...

Posted in 1999

RVASUDEV — Wed, 18 Aug 1999 18:27:38 +0530 — source: Informix-list mailing list archive (1991-1998)

Try SET TABLE table-name MEMORY_RESIDENT Needs to be done by user informix, so best to put it into some startup script for the Informix server, unless you only want it on occassion. HTH Vasudev > -----Original Message----- > From: Marshall Turner [SMTP:t-tech@home.com] > Sent: Wednesday, August 18, 1999 8:26 AM > To: informix-list@iiug.org > Subject: Re: Loading into Shared Memory... > > 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. >