Viewing 2 posts - 1 through 2 (of 2 total)
I ran the profiler and it appears that every time the SP is executed via the .NET ASP app it recompiles and loses all performance. I can set to...
August 28, 2002 at 4:52 pm
#435575
It is faster in QA. I have tried the option (keepfixed plan) and it does not help. It also does not seem to help to recompile the SP....
August 28, 2002 at 2:39 pm
#435557