Re: Performance large tables.

On Dec 13, 2005, at 2:49 AM, Franz(dot)Rasper(at)izb(dot)de wrote:

> What is the performance difference between U320 15kRPM and U320
> 10kRPM ?
> Does your RAID crontoller has some memory (e.g. 128 MB or 256 MB )
> and something like memory backup write cache (like HP DL 380 server) ?
> Do you use Intel or Opteron cpus ?

The 15k drives have higher sustained throughput so theoretically they
would be faster for sequential scans of data. I have no hard numbers
about this, though. See my thread on choosing between them from last
thursday.

As for RAID controller, I've been using LSI MegaRAID 320-2x
controller lately. I like it a lot. I configure 1/2 the disks on
one channel and 1/2 on the other and RAID mirror and RAID 10 them
across the channels. I *always* get battery backup for the
controllers. No point not to do so.

As for Intel vs. Opteron: Opteron hands down. The Intel Xeon EM64T
are adequate for low-end use, but for really pushing the bits back
and forth the Opterons are the top of the heap in performance.