Re: Loading tables in Shared Memory

peeyush wrote: > > Hi, > > I need to know how to load some of the frequently used tables (like master > reference tables which are accessed very frequently) into SHARED MEMORY. By > loading them into shared memory, they permanently reside there until they > are unloaded, and the application programs access these tables from the > SHARED MEMORY rather than the disk, reducing the i/o time. > > How does one load the tbale into SHARED MEMORY and how to ACCESS data once > the table is loaded in SHARED MEMORY. > snip.... P. - When you reference the table, it will get moved into shared memory page by page as referenced, and stay until it becomes the least recently used page, thus getting cast out. Soooo....If you really reference it frequently, it will be extremely likely to be there. If it's not, you either aren't referencing it as frequently as you think, or you don't have enough physical memory/BUFFERS configured. In a sentence - if you have enough physical memory and Informix BUFFERS configured, what you want should take care of itself. -- Greg Moye Electronic Data Systems Corp. - Plano TX