I have a news site in ASP.NET MVC, where all the data comes from the homepage of the database. And this is generating a large traffic to my hosting server.
I have sessions like: Politics, Sports, World, among others, and each session is a different request made to the database. But each request only a small number of data is returned from the database, maximum 8 results for query. In total there are 21 requests made to the database.
I thought about making a data.json file and persist the session information in this file and show them in the frontend.
But as the file data.json and not a database, I have to do all the work to relocate the information when an action to delete or edit is performed.
Is there a better way to get to the point I want, considering that the site is already published?