Recordset Cursors (ADO)

   

Your application may be using the ActiveX™ Data Objects (ADO) Recordset object to provide query results. If so, you should understand when to use each of the four types of cursors available in the ADO Recordset object. The following table describes these options.

Cursor type Recordset type Comments
Forward-only Forward-only If you only need to view each row one time, the forward-only cursor is fast and very efficient in its use of system resources.
Static Snapshot If your application does not need to see changes, a static cursor with a snapshot recordset may work.
Keyset Dynaset If your application needs to see changed rows, and there is no concern about added or deleted rows, the keyset cursor with a dynaset recordset is a good choice.
Dynamic Dynamic If your application needs to see all changed rows, row order, and row values, the dynamic cursor with a dynamic recordset is a good choice.