If your application only needs to read through records in an external table in a single pass, you can dramatically increase the performance of your application by using the forward-only-type Recordset object. Although this type of Recordset object limits the direction of travel through the recordset and restricts the use of a few other methods, it offers perhaps the greatest performance improvement possible when used with large external tables. In an ODBCDirect workspace, the default Recordset object is the forward-only type. The following methods are unavailable when you use the dbOpenForwardOnly constant to create a forward-only-type Recordset object. The Bookmark property is also unavailable.
| Unavailable methods with forward-only-type Recordset objects | ||
| Clone | FindFirst | FindLast |
| FindNext | Move (with any value other than 1) | MoveFirst |
| MoveLast | MovePrevious | OpenRecordset |
See Also For more information about the forward-only-type Recordset object, see Chapter 5, “Working with Records and Fields.”