Re: Informix and RAID

Glenn Brackenridge wrote: > > Hi, > > I wrote something for my employer Baydel > > http://www.baydel.com/informix.html > > Don't confuse fragmentation and RAID. Fragmentation on different volumes > will work fine, but won't give you the benefits of hardware RAID. > Fragmentation on a RAID split into different volumes may suffer from > contention and waste some of the efforts of Informix. If you pick a RAID > system with good performance, and in our case, if the application likes > cache (plenty of writes, and frequent scans, searches, and hot indexes) then > go ahead with the RAID, it will hide the effect of any contention. > > Informix seem to have originally placed themselves into a corner by > discounting the use of RAID when they didn't actually look at enough RAID > options. I don't think that Informix told you to avoid RAID systems. But in some manuals of specific hardware vendors you can still find the hint, that you shouldn't use RAID 5 for databases. Maybe you contacted a guy who made bad experiences with RAID 5 systems. I think it's better to wonder why the I/O is too slow than to conclude that the reason must be the hardware. Don't stop asking until you really know the reason and never ever believe anyone, with the exception of god. Bye Stefan Weideneder