As cheap as disk space is, I think it's mostly a matter of personal taste. If you
need to write much, Raid 0 or 1 will be somewhat faster. If you mostly read, Raid 5
provides a nice additional level of protection without consuming double the disk
space. Just make sure you have enough Raid5 dbspaces/chunks so that you can get lots
of page cleaners cranking in parallel for quick checkpoints.
Definitely don't Raid 5 the write intense stuff, that will really smart.
greg
Jeff Craig wrote:
>
> Does anyone have any sage advice regarding implementing an Informix
> database on a RAID-5 system? I am wondering how best to use Informix
> fragmentation in light of the fact that RAID-5 has already striped the
> data across disks. Since a RAID-5 "logical" drive is composed of several
> physical drives over which data is spread by the RAID software, should
> I try to fragment across logical drives? Should I skip Informix
> fragmentation for RAID-based data? I am not planning on putting the
> write-intensive stuff (logical and physical logs, temporary chunks, etc.)
> on RAID-5.snip....
Greg Moye
Electronic Data Systems Corp. - Plano TX