Re: Informix data fragmentation or RAID disk

Clem Akins writes: |> There are a couple of articles on RAID and Informix that were published |> by Informix Client Service Engineers in the last couple of years. Their |> titles are: |> "Implementing High Availability Informix Solutions With Unix" |> August 1993 |> "The Benefits of RAID Technology in an Informix Environment" |> June 1994 Note that both of these articles pre-date the release of OnLine 7.10, so they will not take into account (as far as I know) fragmentation issues. Simply put, striping with a RAID device (as opposed to fragmenting a table via SQL) eliminates the ability to do parallel i/o against the table, which in turn can limit the amount of parallelization that can be done for the query. This is not to say you can't combine striping and fragmentation; whether that benefits you depends on a lot of other criteria. 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