Re: striping versus round robin

rtt writes: |> I am about to upgrade from online 5 to 7 and am sitting with a query. |> This is to be done on an HP K200 dual process unix box. |> Do I use HP's disk striping to create a raw logical volume accross |> my six disks or do I round robin my large tables across these disks ??? |> The large tables are 2,5 million rows and larger and the rowsize is |> extremely large. +- 300k per row. These tables are also hard hit with |> access. They also have +- 12 indexes on each one. |> Can anybody help ????? Well, this is some new info. Some tests that some of us have done lately are pointing to an advantage in combining disk striping with fragmentation. That is, create your raw logical volumes by striping them across your disks, then fragment your table across those logical volumes. Now many of you will cry, "thrashing!" at this suggestion, and I admit that I would tend to do so too. But it would seem that the throughput gained by using this method is more than compensation for the increased head movement it is likely to cause. Dave Kosenko Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney