Inhalt eines Blobfeldes nur bei Abruf laden

[Olli73]

Prüf mal bei den ODAC-Komponenten folgende Einstellungen:

TOraDataSet.OptionsDS ->

CacheLobs
If True (default value) then local memory buffer is allocated to hold a copy of the Lob content. See notes below for further details.

DeferredLobRead
If True then all Oracle 8 Lob values are only fetched when they are explicitly requested. Otherwise entire record set with any Lob values is returned when dataset is opened. Whether Lob values are cached locally to be reused later or not is controlled by CacheLobs option.

Notes:
CacheLobs option controls the way Lob objects are handled while the application fetches records from the database. Setting CacheLobs to False may bring up the following benefits for time-critical applications: reduced traffic over the network since Lob objects are only transferred on demand; less memory is needed on the client side because returned record sets do not hold contents of Lob fields. Actual value for the Lob field is passed to the client only when a data-aware control requests it.

Gruß,
Olli