TOraDataSetOptions.PrefetchLobSize Property

Used to retrieve the LOB length and the LOB data beginning during regular fetch.

Class

TOraDataSetOptions

Syntax

property PrefetchLobSize: Integer default 0;

Remarks

Use the PrefetchLobSize option to retrieve the LOB length and the chunk size as well as the beginning of the LOB data along with the locator during regular fetch. The PrefetchLobSize property specifies the size of LOB data that will be prefetched. If the total LOB size is less or equals to PrefetchLobSize, then all LOB data will be fetched during regular fetch without additional round trips that can improve performance greatly.

Note: Prefetching LOB data is available in Oracle 11 and higher.