Strategies to maintain counters sorted row ?

[Aditya <ad...@gmail.com>]

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 ?

Re: Strategies to maintain counters sorted row ?

[Aditya <ad...@gmail.com>]

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 <ad...@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 ?
>