Chapter 8: Understanding Cursors and Locks

It is important to understand how cursors operate so you can select the best and most efficient cursor type for an application's data-access requirements. A less-than-optimal cursor configuration can make data-access operations painfully slow.

Many capabilities of the ADO Recordset object are determined by the type and location of the cursor, as well as the lock type.

This chapter covers the following topics:

• What is a Cursor?
• Types of Cursors
• The Significance of Cursor Location
• The Microsoft Cursor Service for OLE DB
• What is a Lock?
• Using CacheSize
• Cursor and Lock Characteristics