Thanks Aaron. On Jan 2, 2013, at 2:55 PM, aaron morton <aa...@thelastpickle.com> wrote:
>> Currently I'm thinking of having a separate Counter CF just to keep the >> number of unread messages in there. Is this a good approach? > Yup. > Add a UserMetrics CF with columns for the counts you want to keep. > > Cheers > > ----------------- > Aaron Morton > Freelance Cassandra Developer > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 3/01/2013, at 8:37 AM, Drew Kutcharian <d...@venarc.com> wrote: > >> Happy New Year Everyone! >> >> What's the best way to model "unread messages count" in Cassandra? I have a >> UserMessage CF where the row key is the user id and the column name is the >> message id (timeuuid) and I store the message and the status (READ/UNREAD) >> in the value column. I would like to be able to show the number of unread >> messages to the user. Currently I'm thinking of having a separate Counter CF >> just to keep the number of unread messages in there. Is this a good >> approach? Is there a better one? >> >> Thanks, >> >> Drew >