RE: What do you call a DBA who ..

Short version: I had to replace the root drive due to size limitations. When We came back up, the database was slower than on the old drive. We couldn't figure out why. I spent longer than I care to admit looking into issues with the new 9GB drive. Then in San Diego I went to the tuning session, and they mentioned: "Make sure your links point to the character special file and not the block special..." It immediately dawned on me what I had done. The day I got back from the conference I got numerous calls saying the system was running faster than ever. Live and learn. At least I have a solid case to attend the conference every year, a 15-20% performance boost is hard to argue with :) -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, June 27, 2000 6:04 PM To: Scott Black Subject: Re: What do you call a DBA who .. Scott Black wrote: > > Then tell us how much faster the system is. When I did this (blush) we > got an extra 15% easily, maybe 20%. When you switched from COOKED to RAW you got an extra 15-20% performance boost? That would be exactly in line with expectations. Read my numerous spouts on the subject of RAW DEVICE -vs- COOKED DEVICE -vs- COOKED FILE performance in the IIUG Archive of CDI. There should have been a few this year. Art S. Kagel > -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Sent: Tuesday, June 27, 2000 10:37 AM > Posted To: informix > Conversation: What do you call a DBA who .. > Subject: Re: What do you call a DBA who .. > > My old boss? > > Just shutdown the engine, relink to the equivalent RAW devices, and > restart. > All will work fine. > > Art S. Kagel > > Hans Siebrand wrote: > > > > A simple question. What do you call a DBA who does all the right > things by > > having symbolic links to the disk device, but then goies and links to > the > > blocking device and not the raw device? > > > > This is what I came across on one of my systems. > > > > -- > > Hans Siebrand > > ~~~~~~~~~~ > > Data Analyst > > Iluka Resource Limited > > > > Ph: +61 8 9780 3215 > > Fax: +61 8 9727 2353 > > Email: hans.siebrand@iluka.com