PgDAC

TPgDataSetOptions.PrefetchRows Property

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

Class

TPgDataSetOptions

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.

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