Re: CREATE TABLE in volatile memory ?

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 -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe