Re: Design for 'Most viewed Discussions' in a forum

2011-05-18 Thread openvictor Open
Sorry I made a mistake in topics-seen ! When you insert it should be : topics-seen[topic:TopicX:timestampN]={TimeUUID3:whatever} Sorry about that, Victor 2011/5/18 openvictor Open > I guess you can use the same system, you need two CF for that and I think > it's better to use 0.8 because it su

Re: Design for 'Most viewed Discussions' in a forum

2011-05-18 Thread openvictor Open
I guess you can use the same system, you need two CF for that and I think it's better to use 0.8 because it supports counter : One CF with UTF8Type called active-topics one CF with UUIDType called topics-seen, then using the same principle : for each timestampN you create : For each visit to Top

Re: Design for 'Most viewed Discussions' in a forum

2011-05-18 Thread Aditya Narayan
Thanks victor! Aren't there any good ways by using Cassandra alone ? On Wed, May 18, 2011 at 11:41 PM, openvictor Open wrote: > Have you thought about user another kind of Database, which supports > volative content for example ? > > I am currently thinking about doing something similar. The bes

Re: Design for 'Most viewed Discussions' in a forum

2011-05-18 Thread openvictor Open
Have you thought about user another kind of Database, which supports volative content for example ? I am currently thinking about doing something similar. The best and simplest option at the moment that I can think of is Redis. In redis you have the option of querying keys with wildcards. Your pro

Re: Design for 'Most viewed Discussions' in a forum

2011-05-18 Thread Aditya Narayan
I would arrange for memtable flush period in such a manner that the time period for which these most viewed discussions are generated equals the memtable flush timeperiod, so that the entire row of most viewed discussion on a topic is in one or maximum two memtables/ SST tables. This would also hel

Design for 'Most viewed Discussions' in a forum

2011-05-18 Thread Aditya Narayan
* For a discussions forum, I need to show a page of most viewed discussions. For implementing this, I maintain a count of views of a discussion & when this views count of a discussion passes a certain threshold limit, the discussion Id is added to a row of most viewed discussions. Thi