Temp DB Spaces in RAM
Posted in 2000
> Company Name: Oxford GlycoSciences > Contact Name: David Griffiths/Angus Couper 01235 208000 > Contract Number: 2130/2054 or 2130/3414 > Hardware: Sun E450 x 4CPUs (moving to E10K) > OpSys: Solaris 2.6 (SunOS 5.6) > Informix Products: Universal Server 9.14.UC2/8 WebBlade 3.31.UC2 > > Should I put my temp spaces in memory (i.e. on RAM disk)? > We are moving to a new E10K machine. In planning the layout of database > spaces, a question has been asked. > Why not place the temp spaces in memory (i.e. on a RAM disk) ? > Please would you advise me. > The space would have to be cooked and would be completely empty whenever > the machine was re-booted. > My Unix sysadmins advice me that, despite the disadvantage on the space > more being raw, it would still be many times faster. > > Thanks in advance, > Angus > ********************************************************************** The information transmitted by this email is private and confidential and is intended for the use of the intended recipients specified therein. If you are neither an intended recipient nor an employee or agent responsible for delivery to an intended recipient, you should be aware that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately. **********************************************************************