Performance with CursorTypes

Results 1 to 2 of 2

Thread: Performance with CursorTypes

  1. #1
    Join Date
    Dec 1969

    Default Performance with CursorTypes

    Firstly, two links:<BR><BR>Choose the Right Cursor for the Right Job<BR><BR><BR>Cursor & LockType Performance Report <BR><BR><BR>In the first article, it is said that Dynamic and Keyset cursors are useless and take up excess resources; while in the second, it clearly shows that in stress-conditions, Dynamic is faster than Static. The only reason I&#039;m asking this and not relying on hard data from the perfromance report is because maybe in non-so stressful conditions, Static IS the right choice for updating data using ADO.<BR><BR>So.....which is true? =<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Performance with CursorTypes

    according to my microsoft book of the world...<BR><BR>adOpenStatic<BR>use when you need navigation other than move next ,and do not need to see changes in the data.<BR><BR>adOpenKeyset<BR>use when need to see edits and deletions to data<BR><BR>adOpenDynamic<BR>use when need to see edits, deletions and additions to data<BR><BR>HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts