Click here to Skip to main content
12,952,273 members (45,161 online)
Rate this:
 
Please Sign up or sign in to vote.
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 5-Oct-12 21:10pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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/[^]
  Permalink  
v2

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,239
CHill60 3,490
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,880


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 6 Oct 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100