Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi,

Iam using cursor in some procedures.

i want to know if we use cursor,will it take more time consuming or not?

iam updating mass data involving more than 1000 to 50000 records at a time
so i want to know how to minimize the time if we use cursor


Regards
Nirmala Saravanan
Posted

1 solution

In general Cursor has its pros but more cons. I have using an simple approach in in my applicaiton and working with huge amount of data .
check this

http://d4dilip.wordpress.com/2010/04/15/avoid-use-of-sp_xml_removedocument-and-cursor-in-stored-procedure/[^]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900