Re: RAID 5 hardware and different dbspace ?

Posted in 2006

Art S. Kagel — Thu, 09 Feb 2006 15:28:29 -0500 — source: Usenet: comp.databases.informix

hapion@yahoo.fr wrote: > Is there a interest to separate tables on different dbspaces if disks > are managed by a RAID 5 hardware If you're asking "Is there any benefit to distributing tables across multiple dbspaces when my disk farm is striped across multiple spindles anyway?" the answer is yes. You will gain at several levels even if you do not use table fragmentation. If you do fragment larger tables you will gain even more. If you are asking whether you should use RAID5 for those dbspaces, the only useful answer is: NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! " Search the CDR archives for January where I posted my periodic NO RAID5 rant recently, or go to www.baarf.com where you can also find that and discussions from experts on the subject, for details on what's wrong with RAID5. Art S. Kagel