August 4, 2003 at 12:15 am
How can i optimise stored procedures in all
ways.
August 4, 2003 at 12:44 am
Hi haremeher,
quote:
How can i optimise stored procedures in all ways.
what so you mean by 'optimise'?
With respect to runtime, reusage, resource utilization, readability.......?
There are hundreds and thousands approaches to this. And yet no general recommendation, I think. So it depends on the specific case.
Maybe some example would be helpful?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
August 4, 2003 at 1:59 am
An SP is basically no more then a compiled set of TSQL commands. If you put those commends into an SP and you just call the SP name from your application you have made the first optimization step.
Therefore you have to optimize you SP as you would optimize your "normal" TSQL script. No more, no less.
Bye
Gabor
August 4, 2003 at 8:19 am
Hi,
This link
http://www.sql-server-performance.com/stored_procedures.asp
provides some of the general recommendations to optimize stored procedures which might be of help...
and like Frank said - there are many ways to "optimize" stored procedures and most of the optimization is dependant on the SP and the requirement....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply