I've been using php + mysql to store page hit to database.
But when it comes to querying daily/last week/last month hits, it quickly becomes slow as the data is growing in millions of rows.
Is there any tech stack recommended to do this?
For now I pull data from google analytics, but this is not a solution because I've got members, and they wrote articles, and need to know their article analytics.