caching a resultset

[habneh]

Here is my question, please tell me whether we can do it or not.
can we cache a resultset of a query for later use, like we cache an execution plan of a query to be reused later.
The reason I am asking is
I want to catch a resukt of a query and reuse it later unless the result set is changed.

please comment on this

thanks

 

[ptheriault]

You can not cache the result set they way you want to within SQL Server. However, keep in mind that SQL Server has a data cache. When you run a query you data is saved in the data cache and depending on how much memory is in your system, (how long data stays in memory before it is paged out)
you just have to re-run your query and you will get the data faster than the first time you ran the query. You query plan is also cached in the procedure cache. If you want to keep your result set in cache you should do it on the application side.

- Paul

- If at first you don't succeed, find out if the loser gets anything.