SET_OPEN_MODE¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
This command is used to enable an option known as “Lazy Open Mode”. When turned on the table’s metadata i.e. table, columns, index descriptions, is deferred until a field is accessed, even if a OPEN has already been done. This can significantly improve an application’s initial performance, especially when a large number of files are opened when the program is launched. By default, tables are set to open normally, but by passing the constant LAZY_MODE to this command, it can be altered to use this mode. Note that when this mode is activated, it effects all tables that are opened. To deactivate this feature, pass the constant “DEFAULT” to this command at any time. This is the preferred method to activate or deactive this feature but it can also be set globally in the .INI file.
Default Value: DEFAULT (Off)
Syntax
SET_OPEN_MODE to {DEFAULT/LAZY_MODE}
Parameter |
Description |
|---|---|
DEFAULT |
Used to turn of the lazy mode feature. |
LAZY_MODE |
Turns on the lazy mode feature |
Example
SET_OPEN_MODE TO LAZY_MODE
Open "customer.int" as Customer
...
...
Find gt Customer by Index.1