How to store the number of views for 30 days?

Question

MySQL

Good afternoon! Tell me how to implement the ability to display the number of views of each article for 30 days?
It turns out it is necessary to store record of each viewing in the separate table? After all, these are hundreds of thousands of records ... Or is there a simpler way for the database?

Answer 1

Table article id, month-year, counter. The counter is incremented. The month changes - a record is added - another counter starts to increase, the old one is stored in the archive.