Home > DeveloperSection > Interviews > Write some disadvantage of Cursor?

Posted on    May-11-2011 4:53 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1219  View(s)
Rate this:

Awadhendra Tiwari

Total Post:510

Posted on    May-11-2011 12:00 AM

Cursor plays there row quite nicely but although there are some disadvantage of Cursor .
Because we know cursor doing roundtrip it will make network line busy and also make time consuming methods. First of all select query gernate output and after that cursor goes one by one so roundtrip happen.Another disadvange of cursor are ther are too costly because they require lot of resources and temporary storage so network is quite busy.

Don't want to miss updates? Please click the below button!

Follow MindStick