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. |