用PHP编写的顶级内容系统

Question

I want to write a top articles system.

I want to filter some content (articles/etc..) by number of views.

If I insert in database with views=views+1 every time when a user view that link, I think it's slowly and it's a bad practice.

An example of another site that does this is YouTube. It updates this table only at a certain interval, so the views aren't updated live. Is this a good practice to do this?

Answer 1

You could create a log (simple text file / xml / Json ………) to store the view count and do a job to parse the file and insert the result into the DB.

This job could run in time intervals or check the system for idle processor.

In my opinion, using the RAM to store sensitive data as this count (an important part of your system) seems kind of insecure.