On Tue, Feb 16, 2010 at 11:56 AM, Weijun Li <weiju...@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. -Brandon