PgDAC

TSmartFetchOptions.LiveBlock Property

Used to minimize memory consumption.

Class

TSmartFetchOptions

Syntax

property LiveBlock: Boolean default True;

Remarks

If LiveBlock is True, then on navigating through a dataset forward or backward, memory will be allocated for records count defined in the the FetchRows propety, and no additional memory will be allocated. But if you return records that were read from the database before, they will be read from the database again, because when you left block with these records, memory was free. So the LiveBlock mode minimizes memory consumption, but can decrease performance, because it can lead to repeated data reading from the database.

The default value of LiveBlock is False.

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