sql server new users: How to run my Curser more faster? -- sql server new users

How to run my Curser more faster?

raj
11/28/2004 4:11:02 PM

sql server new users: I have a stored procedure written for number of updates, inserts to the
database. This stored procedure takes too long to run. I have created few
indexes around few tables, but the response time is not that defferent.
THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and
another stored procedure is called within this Curser. I found that lot of
time been taken to run this Curser. So I want to run/make it faster the
curser. So how should I improve the Curser to run more faster
I would greatly appreciate anyone's idea or suggesions.

thanks

Re: How to run my Curser more faster?

Jacco Schalkwijk
11/29/2004 5:12:22 PM

[quoted text, click to view]

By getting rid of it. Seriously, cursors are slow, and performance will be
better if you don't use cursors. If you need any help, post your code on
this newsgroup. See www.aspfaq.com/5006 for details how to post it.

--
Jacco Schalkwijk
SQL Server MVP

[quoted text, click to view]