I've this blog-like system (LAMP) and I'd like to track number of views of every article. Now, is it better to update the article's views column every time the article is viewed or use some temp table, where I'd store only the article ID, and then (let's say every hour) run a query that would take the data from the temp table and update the rows in the articles table? I'm open to completely different solutions.
Note that I can't use any analytics tools as I need to work with these numbers (most popular etc.).