Visual Basic: RDO Data Control
RowsetSize Property
See Also Example Applies To
Returns or sets a value that determines the number of rows in an rdoResultsetcursor.
Syntax
object**.RowsetSize** [= value]
The RowsetSize property syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| value | A value that specifies the size of the rowset as described in Settings. (Data type is a Long expression.) |
Settings
The upper limit of the RowsetSize is determined by the data source driver. The lower limit for value is 1, and the default value is 100.
Remarks
The RowsetSize property determines how many rows of the keyset are buffered by the application. RDO uses the RowsetSize property to determine how many rows are read into memory with the ODBC SQLExtendedFetch function. Tuning the size of RowsetSize can affect performance and the amount of memory required to maintain the keyset buffer.
This property must be set before creating an rdoResultset object.
Impact on Pessimistic Cursors
In addition, the RowsetSize property determines how many rows (and data pages) are locked when using Pessimistic (rdConcurLock) concurrency. For example, if you set the RowsetSize property to 100 and execute an rdoQuery object with the rdConcurLock option, the first 100 rows of the result set and every page associated with each row is locked until the cursor is closed or you move the current row pointer toward the end of the result set. In any case, at least RowsetSize rows are locked.