Rodolfo Baselli wrote:

> It's no surprise that RAID0 outperforms RAID1 expecially in the write
> performance.
> Fault tolerance is has its own overhead. A smart RAID controller takes
> advantage in read operations in both cases, but it's definitely
> different in write operations.
> You have to check whether your db configuration or application dml
> statements affect the performance tests (eg. they are the most frequent
> operations).

No DML operations were performed during my tests. I only measured the
time taken by a complex query to complete. The RAID0 server completed
the query in (RAID1 seconds)/6 seconds against the same data.

I know that RAID1 has write overhead, but I'm wondering whether is it
possible or impossible that RAID0 could perform 6 times better than
RAID1 on read operations.

Thank you. Kind regards,

--
Cris Carampa (cris119@operamail.com)
"E` evidente che siamo di fronte allo sfruttamento opportunistico
di quella quota di astensioni fatalmente derivanti da disinteresse
o indifferenza." (Gustavo Zagrebelsky)