Loading tables in Shared Memory

Hi Mickey, Thank You for your response. Im sorry I did not clarify that I am NOT talking about loading the table into INFORMIX SHARED MEMORY, but creating our own SHared Memory in UNIX, and then loading the table into it. I have done it in my earlier project, but that was 2 years back so I have forgotten how to do it. But it IS possible. I know that one has to use esqlc code to access the shared memory (as system calls are involved). Regards, Peeyush -------------------------------------------------------------------------------- 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. Regards, Peeyush Rai (peeyush@toj.com) ================= A___A ====================================================== Peeyush Rai / 0 0 \\ | (o) | ADDRESS: >>> U <<< HOME \\___/ Apt. #302, Gallery Apartments, 17 Oxford Road, Kingston-5, Jamaica (West Indies) Phone : 1-809-9296906 OFFICE Fiscal Services (EDP) Ltd. 235 B Old Hope Road, Kingston-6, Jamaica, The West Indies. Phone: (Off) 1-809-9271125 (to 28) Ext. 284 Fax : (Off) 1-809-9271810 HOME PAGE : WWW : http:/www.isip.msstate.edu/~deshmukh/iitb/mech.html Email: peeyush@toj.com ================================================================================