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
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
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