FireDAC.Stan.Option.TFDFetchOptions.LiveWindowParanoic
Delphi
property LiveWindowParanoic: Boolean read GetLiveWindowParanoic write SetLiveWindowParanoic stored IsLWP default True;
C++
__property bool LiveWindowParanoic = {read=GetLiveWindowParanoic, write=SetLiveWindowParanoic, stored=IsLWP, default=1};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | TFDFetchOptions |
Description
Controls the records search mode of the TFDTable live data window mode.
Use the LiveWindowParanoic property to set up the records search mode of the TFDTable Live Data Window mode.
In general, in order to maintain live data window, FireDAC performs different SQL queries. This can affect the application performance. To improve it, search operations can avoid extra SQL queries, but this leads to a less exact result. If LiveWindowParanoic = False (default value), then TFDTable will avoid the following:
- SELECT COUNT(*) SQL query to calculate the RecNo property value. Instead -1 will be returned.
- SELECT SQL query for the Locate and Lookup methods, when a locating record is found in a local client cache.
Note: The LiveWindowParanoic property is used only when TFDTable is operating in live data window mode. It is not used in standard mode.