Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedure getting slower
Message
From
05/01/2006 04:57:55
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Stored procedure getting slower
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01083448
Message ID:
01083448
Views:
63
Hi,

Anyone faces this issue, of why the same SP in SQL2k SP4
when initially run, is fast and okay.

However, when i run it the second time or more, it just
keep getting slower from 30seconds to 2minutes.

Anyone know who or how it is happening.

My SP just using a cursor and even when
I change it to using loop, it does not
help.

Thank you
Best Regards
Virusim
Next
Reply
Map
View

Click here to load this message in the networking platform