caching sql data

Question

I am in a situation where i have to execute the stored procedure everytime with same parameters in the different functions. I want to cache the values when the sp executes first time and store the data, then i want to retrieve that cache value every time in my different functions. 

 

Is this possible? If yes then please help with any demo code.

Thanks! 

Answer 1

Hi,

You can try this.

http://blog.sqlauthority.com/2014/03/18/sql-server-performance-do-it-yourself-caching-with-memcached-vs-automated-caching-with-safepeak/