I have a site, and when the user does an action I wish to add that to a count of how many actions the person has ever done. Naturally I'd say "update the user table each time!" but I don't feel as if that's a good solution, and I'm interested in seeing if there is a way to do this.
Basically the user would log in and start using actions, and every time they make an action I would do [whatever] and then at the end of the day, I take all [whatever]s and make the query, saving resources on each action. Were the site to grow to 1,000 users, those little queries would start adding up! There is only one type of "action", for the sake of this question just assume each page load would be an action.