Language Reference Guide : System Classes : DBSessionObject Class : PreFetchRows Attribute
 
Share this page          
PreFetchRows Attribute
Data Type: integer
4GL Access: RW
The PreFetchRows attribute lets you set and inquire about the number of rows buffered when fetching data using cursors in read-only mode. The value is reset every time a cursor is opened. When using this feature, set the value before opening a cursor.
Valid values are:
0
Specifies that OpenROAD determines the number of rows to prefetch
1
Specifies that prefetching is disabled, and each fetch fetches one row from the database
n
Specifies the number of rows to prefetch (this value must be a positive number)
Default: 0
For an example of using the PreFetchRows attribute to enhance performance, see the Programming Guide.