Re: cooked vs raw disk in an Data Warehousing environment

From: rkinformix@yahoo.com > >The enviroment is HP N Class machines running HP 10.x. >Informix 9.1 > >Does it really make a difference in having raw disk for storing data in >a DSS environment, as compared to cooked file system. There will be a >monthly incremental load to the Data Warehouse and rest of the time >there will be only queries. The database itself will not have >transactions. Yes. Cooked files are slower than block devices are slower than raw disk. Also, cooked files get buffered by the OS as well as Informix, which can lead to swapping (or at least wasted memory). It is not impossible for the total hit to exceed 35%. >While we are at it, is it easy to manage dbspaces and fragments with >cooked file system as compared to raw disk. What about adding extents >or dbspaces. Is cooked file system easier to handle. I have only used raw disk since the advent of OnLine 5. It's very simple, except for when idiot sysadmins mount and format your raw disks. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.