Help: OFA vs. RAID5 Best Drive Config

From: AF <af_at_nospaming.com>
Date: Wed, 19 Jun 2002 16:37:55 -0700
Message-ID: <aer4vi$i9a$1@pith.uoregon.edu>

I have read conflicting recommendations about HD Config: I have heard that RAID5 is best for Warehouse Apps. I have also read that OFA is the best way to reduce drive contention. Which is better for my system

I have 4-73GB hard drives and a Single Channel SCSI RAID controller. I have a data warehouse type application. The only DML is INSERT and this is done quarterly. There are only a few partitioned tables and they are about 6GB. The Queries are usually complex joins and large aggregate sets. Sometimes these queries require temporary tables that may have Insert and update DML.

Thank You
A Received on Wed Jun 19 2002 - 18:37:55 CDT