Dear Friends,
I have Store Procedure When First Run is Slow but Second Run is Faster
I need to solve the problem
Thank You
Dear Friends,
I have Store Procedure When First Run is Slow but Second Run is Faster
I need to solve the problem
Thank You
that's not saying too much. What does it do? How often is it run, maybe second time is hitting procedure cache and first time it has to generate the cache
The only way you can do that is to prevent recompiles and keep all the data you need in memory all the time.
On a busy system, the latter may be difficult to do especially since most code is performance challenged and resource hungry.