> 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
