Hi, In my page, I have multiple queries to fetch data from same table with different scenarios. These multiple queries give me performance issues. So I am trying to cache the table and then query that with different scenarios and in this way I don't need to hit the database all the time. But, I don't know how to cache the table and query from it. Can anyone help? Is there any other way to improve the performance?
"hitting the database" shouldn't be a problem - I'd look at how well your queries are written, how much data you are pulling back and how well indexed it is before I looked at the caching you describe.