Re: Datawarehouse with RAID 5

In article <5sodb6$1dt@cssun.mathcs.emory.edu>, apsfinfx@santafe.com.ar (Daniel Cernotto) writes: > > Hi, > > Which is your opinion of datawarehouse in RAID 5? That it is Ok to use RAID 5 in a data warehouse implementation. > What are the problems of performance with RAID 5? The major problem with RAID5 is that there is typically a significant impact on writes to the disk arrays. This is due to having to calculate the parity as it is written. In data warehouse type systems, you are doing mostly reads against the data, with writes happening on off hours. In our implementation, we placed the data and index tables on RAID 5 for its redundancy, and placed our temp tables on RAID0, for the speed. - Al > TIA > > Daniel Cernotto -- Al Dorrington awdorrin@ictest.delcoelect.com Delco Electronics - IC CIM Database & Unix Administrator Kokomo, Indiana, USA Phone: 765.451.9655