On Wed, 2010-10-27 at 14:20 +0200, mike anderson wrote: > [...] By my simple math, this would mean that if we want each shard's > index to be able to fit in memory, [...]
Might I ask why you're planning on using memory-based sharding? The performance gap between memory and SSDs is not very big so using memory to get those last queries/second is quite expensive.
