Hi Experts,
I have a windows service that receives a large number of requests from a client. Each request needs few database queries. Most of the time a lot of 20 -30 adjacent requests needs the same queries and results of the queries are identical. So I'm thinking of caching the results.
Can I use the Caching Application Block or I can use an array created per each type of databse query and use it as a cache. For the first query I get data from database and load it to the array for future use.
Which would be the best approach?
Go to the complete details ...