User Id :    Password :      New Member   Forgot Password  
Topic: Write some disadvantage of Cursor
Sachin Jain
29 Oct 2010 at 11:52 PM
Write some disadvantage of Cursor.
Re: Write some disadvantage of Cursor
Gaurav
01 Nov 2010 at 12:02 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 queries generate output and after that cursor goes one by one so roundtrip happen. Another disadvantage of cursor is that they are too costly because they require lot of resources and temporary storage so network is quite busy.

Total Replies: 1
 
Featured Text Ad

Featured Ad