How the "CacheSize" Property Affects Performance

The Recordset object property "CacheSize" indicates how many rows should be cached in the ADO local memory. The following code shows how to set this property:

' obConnection is an open Connection object.
Dim obRecordset As New ADODB.Recordset

obRecordset.CacheSize = 55
obRecordset.Open "seashell.mediate", obConnection, adOpenDynamic, adLockOptimistic, adCmdTableDirect