In my application, I need to store the total scores/reputation of the users as counters and want to show sorted(by score) lists of users. Also want to implement a name search facility on top of that. Could you suggest  any schema to achieve that using cassandra. 


On Wed, Nov 30, 2011 at 12:53 PM, Aditya <adynnn@gmail.com> wrote:
I know it is not possible to sort columns in a row by counter values so what are the other strategies to maintain a sorted list (of counters)  in cassandra? Could you propose some schema that might be helpful to achieve this ? 

Or do I need to retrieve thousands of columns each time and do the sorting at application level ?