Here is a thing: there is a blog-like website which contains some posts. I need to estimate page views of each of those posts and display it next to their content. Moreover, I need to create task that will periodically update home page of website with information about currently "hot"/frequently visited posts.

I could of course create SQL table, treat each post as database record and update it every time any user request post from my website. But I'm worried about performance, I was tought SQL queries are rather expensive.

How would you do such a thing? If I count page views in SQL database, is its performace a thing I should worry about?

PS: No Azure/GoogleAnalitycs soultions. I want to have full control of how page views are counted.