Hi,
At 20:16 18/04/2005, Alex Turner wrote:
>So my assertion that adding more drives doesn't help is pretty
>wrong... particularly with OLTP because it's always dealing with
>blocks that are smaller that the stripe size.
When doing random seeks (which is what a database needs most of the time),
the number of disks helps improve the number of seeks per second (which is
the bottleneck in this case). When doing sequential reads, the number of
disks helps improve total throughput (which is the bottleneck in that case).
In short: in always helps :-)
Jacques.