Re: Loading tables in Shared Memory

peeyush (peeyush@toj.com) 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. You can't do it, at least not unless you are doing it programmatically from within some sort of program that handles its own shared memory. If the table is accessed enough, and if your shared memory is large enough, you can probably figure that Informix will have the pages in shared memory anyway. I suppose you could write a script that accessed the tables from a cron job to be **sure** that it is in shared memory. I haven't tried it, but you could possibly place a small database chunk on a RAM drive and get sort of the same effect. Anybody tried this? What you want is the equivalent of the UNIX "sticky bit" for tables. Can't you do this in Oracle?....I seem to remember seeing this somewhere. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------