Adjusting indexinterval is unlikely to be useful on very narrow rows. (Its purpose is to make random access to _large_ rows doable.)
On Mon, Apr 4, 2011 at 8:38 PM, Chris Burroughs <chris.burrou...@gmail.com> wrote: > I have a case with very narrow rows. As such I have a large row cache > that does nicely handles > 50% of requests. I think it's likely that > the current tradeoff between page cache and row cache is reasonable. > Using a key cache doesn't make sense in this instance. However, a third > option is to adjust the IndexInterval [1] [2]. > > It would theoretically be reasonable to: > - Increase the IndexInterval to make more memory available for row or > page cache. > - Decrease the IndexInterval for more effective sampling. > > When the knob could be turned either direction it's hard to know which > way to start. > > Does anyone have any experince succesfully adjusting the IndexInterval > for improved performance with narrow rows? > > > [1] https://issues.apache.org/jira/browse/CASSANDRA-1488 > > [2] http://www.datastax.com/dev/blog/whats-new-cassandra-066 > -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com
