Re: CREATE TABLE in volatile memory ?

Yes, You don't really provide enough information as to what you would like to do. However there's a difference between making a table memory resident or making a page of the data memory resident. Becareful what you ask for... without enough information, your questions mean something different to different people. What is it that you are trying to accomplish? If you are looking at a small table of temp data that is application centric and its too large to fit in to the app, then you will want to use a ram disk. (Solid state disk, or a virtual disk....) You should really think out the design problem before chosing either technique. But hey, what do I know? ;-) Richard Kofler wrote: > Corne' Cornelius wrote: > >>Hi, >> >>Does informix support tables (non-temporary) which reside in volatile >>memory ? As far as i know, DB2 supports it. >> >>If Informix can't do this, does anyone know how to create a blobspace in >> memory on HP-UX ? I know Linux can do this using the tmpfs. >> >>Thanks, >>Corne' > > > sorry for joining in so late ... > > Best option you have is to consider SSDs > (Solid State Disks) > > There are plenty different ways and price/performance > considerations but www. storagesearch.com/ssd.html has it all in > a very informative way. > > If you need the speed and if you have some money to spend > this simply was always THE way to go. > It is the only way to buffer/keep-incore what ever YOU want > and not what a semi- (un-)intelligent algorithm *thinks* will > be fast for you. > One has to choose the inteface with care, as fibre is only 2Gbit > which is way too slow for having real speed on disks. > > dic_k