Used to set the number of rows to be prefetched during the execution of a query.
property PrefetchRows: integer default 0;
Use the PrefetchRows property to set the number of rows to be prefetched during the execution of a query. Setting the property to a value greater than 0 reduces the server round-trip count, which increases the performance of the application. The default value is 0 - the number of prefetched rows is determined automatically. To disable row prefetching, set the property to -1.
Note: Some queries (for example, query SELECT * FROM DUAL CONNECT BY LEVEL <= 5 returns 1 row when prefetching is enabled, and 5 rows when it is disabled) can return invalid rows count when prefetching is enabled.