RE: Temp dbspaces in RAM

> Hi, > > as long as Informix can handle the memory > it is faster to spend the memory for > the virtual SHM-segment. > I made several tests with RAM-disks > and the DS_TOTAL_MEMORY parameter. It's > better to use DS_TOTAL_MEMORY and PDQPRIORITY. > But if your servers' process space has > reached the limit, you must use RAM-disks > instead ( or use the 64-bit Informix version ). > > Informix allocates and deallocates Extents > even on temporary dbspaces. It's a kind of > double caching and therefore it must be slower > than the virtual DS-memory. Additionally > to avoid errors during the startup of your > IDS you should recreate the RAM-disks > and restore the first 53 Pages on the RAM-disks > before you startup the Informix server. Alternatively used NVRAM for the temp dbspaces. I found the speed increased not to be worth the hassle and the 'cos the system I was on the dbspaces had to be cooked. Paul Watson # WF Software Ltd # All answers are +44 1435 674629 # pure fantasy +44 1436 678693 # www.wfsoftware.com/informix #