Re: Raw vs. cooked

I think a big piece of the puzzle is also what you're doing. Raw writes will always be faster because there is a shorter code path, there is no way around it. On the other hand, reads can come from the file system cache depending on how memory is configured for the RDBMS, etc. What type of benchmark was it? Lots of OLTP style small inserts/updates with unbuffered logging? Or was it more DSS style queries? FProse wrote: > > Using AIX 4.1 and DynamicServer 7.2 on a four processor RS6000, I > found cooked beat raw by a margin of 15%. This was running against > Clarion array disks, the raw was non-raid, the cooked was raid-5. > > The local Informix people checked my results and went away shaking > their heads.