I have a .NET application that will need to make quite a few calls the database based upon users interaction.
I'm quite concerned with the number of times the database will be hit with user interactions, so I have decided to cache the data stored in the database (around 3500 records) into .NET cache. So I am querying my data though a generic list using LINQ within the application.
What I have noticed is that when the cache expires, the website takes a long time to load whilst the cache is populated with data.
Is there a better and more efficient way to cache large amounts of data whilst minimising calls to the database?