DF_FILE_CACHE_MODE¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

Activates or deactivates the local cache for set-oriented searches.

Through the DF_FILE_CACHE_MODE attribute, we can activate or deactivate the local cache. When the cache is active in a set-oriented search, a fixed number of records are pre-fetched and kept in the local cache. If a record is not found in the local cache, a new set is fetched. The number of records fetched is controlled via the DF_FILE_MAX_ROWS attribute. Set-mode vs. one-row mode is controlled via the DF_FILE_SET_MODE attribute.

Note: Turning off the cache can have significant detrimental effects on performance.

Default value: True

Syntax

Set_Attribute DF_FILE_CACHE_MODE of {FileNumber} to {variable}
Get_Attribute DF_FILE_CACHE_MODE of {FileNumber} to {variable}

Parameter	Description
FileNumber	Number of the file
variable	Mode for FileNumber. True for active. False for inactive.

Example

Open Orderhea
Set_Attribute DF_FILE_CACHE_MODE of Orderhea.File_Number to True
Get_Attribute DF_FILE_CACHE_MODE of Orderhea.File_Number to boolVal