RE: Cook device vs Raw device
Correct if I'm wrong (I'm sure someone will :), but I always thought that raw disk only really starts giving you performance gains when it comes to doing lots of writes. Given this, the 1.5% gained below was due to the marginal performance gain from not having to go thru the block device interface for reads. Conversely, if William tried the test again, this time doing inserts/updates/deletes, he'll see very much improved figures. Andrew Reardon UNIX/Informix Administrator AeroSpace Support, Boeing Australia Ltd. Ph: +61 7 3306 3346 Mob: +61 0419 745 831 > ---------- > From: William Rice[SMTP:ricew@operamail.com] > Sent: Thursday, September 16, 1999 6:01 AM > To: William Rice > Cc: informix-list > Subject: RE: Cook device vs Raw device > > This is a thread that has always interested me. I have been reading this > group for awhile, and was concerned when I came to my current place of > employment > and discovered they were using filesystems to hold data. When we > got the oppurtunity to do some limited testing on raw vs cooked we > could only find at most a 1.5% difference between informix's performance > to raw disk vs. cooked. > We watched the following things: > iostat, > vmstat > wall time > > We were running AIX 4.3.2 on a 520 > Informix 7.31UC2 > > Only 2 disk drives, one of which was dedicated to informix data. > Under 2 Gigabytes of data in the whole database > > These processes were simple queries(no more than three tables joined) > and the loading of data into tables. > > The longest running process was somewhere around 15 minutes. > The processes tested caused the system to be heavily io bound for some > and CPU for others. > > From reading the newsgroup I got the impression that I could count on at > least > a 10% difference between cooked and raw, yet the tests I ran did not turn > out > that way. > > The data involved was literally identical. I was curious what factors > might > be causing the performance not to increase. > > Will > > ------------------------------------------------------------ > This e-mail has been sent to you courtesy of OperaMail, a > free web-based service from Opera Software, makers of > the award-winning Web Browser - http://www.operasoftware.com > ------------------------------------------------------------ >