On Tue, Feb 16, 2010 at 11:56 AM, Weijun Li <weijunli@gmail.com> wrote:
One more thoughts about Martin's suggestion: is it possible to put the data files into multiple directories that are located in different physical disks? This should help to improve the i/o bottleneck issue.

Yes, you can already do this, just add more <DataFileDirectory> directives pointed at multiple drives.
Has anybody tested the row-caching feature in trunk (shoot for 0.6?)?

Row cache and key cache both help tremendously if your read pattern has a decent repeat rate.  Completely random io can only be so fast, however.