Re: Informix and RAID?

> > Test IT wrote: > > > > The folks from Informix told me that running Informix on a box in a > > RAID configuration is not the best idea. They say that performance > > drops. Is anyone running Informix 7.11 or > on a RAID box? We're > > talking less than 100 tps and less than 20GB of data. If you > > converted from not RAID to RAID, did you see a big performance drop? > > > > If not RAID then yes, mirroring. Received wisdom suggests that both > hardware and/or UNIX mirroring is preferable to Informix mirroring > 'though. > > Neil > Here's the truth, with todays Fast/Wide SCSIs and other intelligent controllers you are unlikely to experience any appreciable delays by going to RAID 5, truth is it depends much more on your hardware configuration than anything else. If you have an appropriate number of processors, intelligent disk controllers and fast drives it is a moot point, either way will perform well. As for hardware or UNIX mirroring, if you are running OnLine 6.x or above it is far better to use Informix mirroring. The reason is because the engine is intelligent enough to know that on sequential scans it can simultaineously read both the primary and the mirror drive to get the data. nuff said Michael Strother Informix