Alex Rivera | Logout

Keeping Track of User Points (Like SO)

Asked 2010-03-01T23:37:21.120
12

I want to be able to keep track of user points earned on my website. It isn't really like SO but the point system is similar in that I want each user to have a total and then I want to keep track of the transactions that got them to that total.

Should I keep a user total in the User table or should I just pull all the transactions that affect the User in questions point total, sum them and show the point total?

Seems like the latter is more work than needs to be done just to get the total. But then again I cringe at the idea of keeping the same data(more or less) in two different places.

What's the right way to design this?

EDIT: Took the advice. Using both and recalcs. I added a RecalcDate column, and if its over a day old it gets recalced. The total also get recalculated everytime a user does something that should affect their point total.

c# asp.net sql
Edit
Report

1 Answer

9

Both

You need to have a way of recalculating totals when things go wrong, say you add a new feature, or someone learns to exploit the system. You can keep a current total on the user table and a record of transactions to recalculate that total when needed...not every time you need the value to display.

You're not storing duplicate data so much as the audit history to fall back on, the only duplicate is one number in one column on the User table...the alternative is a user exploits the system, there's no way to roll it back. The same thing happened in the early days of SO, but they had the history and could recalculate totals without a sweat.

answered 2010-03-01T23:42:35.707

Your Answer