Re: IndexInterval Tuning

2011-04-05 Thread Jonathan Ellis
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

Re: IndexInterval Tuning

2011-04-05 Thread Jonathan Ellis
On Tue, Apr 5, 2011 at 8:54 AM, Jonathan Ellis jbel...@gmail.com wrote: Adjusting indexinterval is unlikely to be useful on very narrow rows. (Its purpose is to make random access to _large_ rows doable.) Whoops, that's column_index_size_in_kb. I'd play w/ keycache before index_interval

Re: IndexInterval Tuning

2011-04-05 Thread Chris Burroughs
On 04/05/2011 09:57 AM, Jonathan Ellis wrote: On Tue, Apr 5, 2011 at 8:54 AM, Jonathan Ellis jbel...@gmail.com wrote: Adjusting indexinterval is unlikely to be useful on very narrow rows. (Its purpose is to make random access to _large_ rows doable.) Whoops, that's column_index_size_in_kb.