FireDAC.Stan.Option.TFDFetchOptions.Cache
Delphi
property Cache: TFDFetchItems read GetCache write SetCache stored IsCS default [fiBlobs, fiDetails, fiMeta];
C++
__property TFDFetchItems Cache = {read=GetCache, write=SetCache, stored=IsCS, default=7};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | published | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | TFDFetchOptions |
Description
Controls what kind of data to cache in the memory.
Use the Cache property to control what kind of data and metadata to cache in the internal data storage.
Option |
Description |
---|---|
|
If included, then the BLOB field values are not discarded from the memory after usage. If excluded, then, after changing the current dataset record, BLOB field values in the current record will be discarded. |
|
If included:
|
|
If included, then the command metadata is not discarded from the memory after usage. If excluded, then after fetching and using required metadata (eg, primary key fields), it will be discarded from the cache. |
The default value is [fiBlobs
, fiDetails
, fiMeta
], meaning that all data and metadata will be cached after usage.
Note: Excluding items from Cache does not affect already fetched data or metadata.