Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
redbrad0
Posting Yak Master
176 Posts |
 Posted - 2005-07-13 : 19:07:03
|
We are currently programming in C# and were looking to parametrized query to cache the results.quote:
SQL server will also cache the execution plan of a parameterised query. This means the next time you run the same query, the database will already know how to execute your query in cache, speeding up access.
Has anyone ever done this? I am trying to cache a SP which is getting the results from a program called SQL Turbo.Quality NT Web Hosting & Design |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-07-13 : 19:29:27
|
| Caching query RESULTS is different from caching the query's PLAN. You can cache the results simply by storing a DataSet or DataTable into a .Net Cache object. This caching would be completely independent of SQL Server, if you execute the query again SQL Server will process it all over again. Even if the plan is cached it will return the entire result set. |
 |
|
|
|
|
|
Caching SQL Query Results