Page View Counter like the one here on StackOverFlow?

What is the best way to implement the page view counter like the one found开发者_运维百科 here on this site where each question has a "Views" counter using PHP and MySQL??

---

I think you should take a look at that discussion, which already covers what you're trying to do. Page Views counter using PHP and MySQL?

You would need to increment a counter in the database every time the page the page is loaded. In the url above, there was a specific table for this counter. But you can only add a "views" field in your post database and increment it the same way.

---

It depends on the amount of traffic your site is getting and in speed.

If you want scalability I'd use caching with a fixed expiration time set and increment values within cache and when cache will get expired a callback would transfer that number to MySQL database. This way things will be scalable and you will save lots of database calls hence speeding up responses.

But I can't advise you on caching in PHP since I'm on MS technologies. Others will provide answer to this.