So I am developing a website which will allow users to comment on things. As part of this I need to display a comment count and I wanted to know what you thought was the best way of doing this:
The two options are
Every hour/day run a CRON that counts the comments on a certain item and then updates the articles DB entry
As soon as a comment is added +1 to the comment count
I should mention that this will be a highly used site (estimating 1,000,000+ hits per month)
Which is the best way of doing it?