incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ertio Lew <>
Subject Columns values(integer) need frequent updates/ increments
Date Thu, 07 Apr 2011 20:32:03 GMT

I am working on a Question/Answers web app using Cassandra(consider very
similar to StackOverflow sites). I need to built the reputation system for
users on the application. This way the user's reputation increases when s/he
answers correctly somebody's question. Thus if I keep the reputation score
of users as column values, these columns are very very frequently updated.
Thus I have several versions of a single column which I guess is very bad.

Similarly for the questions as well, the no of up-votes will increase very
very frequently and  hence again I'll get several versions of same column.

How should I try to minimize this ill effect?

** What I thought of..
Try using a separate CF for reputation system, so that the memtable stores
most of the columns(containing reputation scores of the users). Thus
frequent updates will update the column in the memtable, which means more
easier reads as well as updates. These reputations columns are anyways small
& do not explode in numbers(they only replace another column).

View raw message