I would suggest you to create a CF with a single row (or multiple for historical data) with a date as key (utf8, e.g. 2011-12-22) and multiple columns for every user's score. The column (utf8) would then be the score + something unique of the user (e.g. hex representation of the TimeUUID). The value would be the TimeUUID of the user.
By default columns will be sorted and you can perform a slice to get the top 10. 2011/12/14 cbert...@libero.it <cbert...@libero.it> > Hi all, > I'm using Cassandra in production for a small social network (~10.000 > people). > Now I have to assign some "credits" to each user operation (login, write > post > and so on) and then beeing capable of providing in each moment the top 10 > of > the most active users. I'm on Cassandra 0.7.6 I'd like to migrate to a new > version in order to use Counters for the user points but ... what about > the top > 10? > I was thinking about a specific ROW that always keeps the 10 most active > users > ... but I think it would be heavy (to write and to handle in thread-safe > mode) > ... can counters provide something like a "value ordered list"? > > Thanks for any help. > Best regards, > > Carlo > > >