f2s_table_static_mode¶
Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers
Syntax
set_attribute f2s_table_static_mode of {FileNumber} to {variable}
get_attribute f2s_table_static_mode of {FileNumber} to {variable}
Parameter |
Description |
|---|---|
FileNumber |
Number of the file (filename.File_Number) |
variable |
Boolean variable. Static mode for the file. True for static, false for dynamic. Default = false |
Description
Activates or deactivates a special table mode where all rows from the table are loaded into a local cache. When active, all searches are done in memory and the actual table is not accessed. The driver does not allow editing of a table in static mode.
When to Use
This is a very useful feature especially when a table contains configuration or static information used in calculations, (i.e., Tax Rate tables, etc.) By keeping this table locally in memory, network round trips are saved resulting in significant performance improvements. This attribute is also useful for batch processes that make extensive table IO requests for reading static information.
When not to use
Because the entire table is loaded into memory, it is inadvisable to use this on very large tables.
Examples
get_attribute
boolean bStatic
Open OrderHea
Get_Attribute f2s_table_static_mode of Orderhea.File_Number to bStatic
set_attribute
Open OrderHea
Set_Attribute f2s_table_static_mode of Orderhea.File_Number to true
Replaces: DF_FILE_STATIC