Hi, 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).
