Re: Effect of disk striping on disk layout

From: John Bejarano <jbejaran@my-dejanews.com> > >My new company has an INFORMIX server that is agonizingly slow. Much of >this may be due to the application running against it, but I can tell >that disk I/O on this system was poorly implemented. I've suggested >ways of balancing I/O (i.e. putting heavily hit tables on separate >drives, and toward the physical center of those drives), the usual >stuff. > >System Admin is more interested in disk striping to try to increase >performance. I've told them that implementing RAID takes one form of >performance tuning out of my hands. Based on your experience, would you >recommend going with an improved disk layout, or with disk striping, or >some sort of combination? Thanks very much for any insight you can >contribute. Make a deal with him, he can stripe, provided he doesn't get to use RAID 5. Mirror and stripe at the hardware level. *However*, I rarely believe that this kind of thing will solve the problem on it's own. I therefore declare the assumption that you've: 1) Got the right indexes; 2) Got the right statistics; 3) Profiled the code; and 4) Tuned the engine. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com