Re: effective modeling for fixed limit columns

2010-04-19 Thread Jonathan Ellis
Limiting by number of columns in a row will perform very poorly. Limiting by the time a column has existed can perform quite well, and was added by Sylvain for 0.7 in https://issues.apache.org/jira/browse/CASSANDRA-699 On Fri, Apr 16, 2010 at 1:50 PM, Chris Shorrock wrote: > I'm attempting to co

Re: effective modeling for fixed limit columns

2010-04-16 Thread Mike Gallamore
The problem I'm working on is very similar to this. I'm working on a reputation system and we keep a fixed number of day buckets for the scores. So when new data comes in you need to find out what bucket is supposed to be used, remove the data in it if you've moved to a new bucket as the data t

effective modeling for fixed limit columns

2010-04-16 Thread Chris Shorrock
I'm attempting to come up with a technique for limiting the number of columns a single key (or super column - doesn't matter too much for the context of this conversation) may contain at any one time. My actual use-case is a little too meaty to try to describe so an alternate use-case of this mecha