ODAC

TOraDataSetOptions.PrefetchRows Property

Used to set the number of rows to be prefetched during the execution of a query.

Class

TOraDataSetOptions

Syntax

property PrefetchRows: integer default 0;

Remarks

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.

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback