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 ch...@shorrockin.com wrote:
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