On my webpage, I've got a seach function that returns quite alot of data. I would like to store the results of the initial search, so when paging through the result pages I don't have query the database again but use the cache results instead.
Initially I was using HttpContext.Cache["results"] to store the search results. But then I realised that this is a global cache, so different users will keep overwriting this value (different users will be searching different queries at the same time).
I'm thinking of storing the data in a session eg. session["results"], but I want to ask you guys what's the best way to do this?
View Complete Post