| Note | This command is defined in a header file and will be preprocessed by the X# preprocessor to a function call. If you disable the standard header (-nostddefs) files then this command will not be available. If you tell the compiler to use a different standard header file (-stddef ) then this command may also be not available |
Purpose
Change the setting that determines whether to optimize using the open orders when processing a filtered database file.
Syntax
SET OPTIMIZE ON | OFF | (<lToggle>)
Arguments
| ON | Turns optimization on. |
| OFF | Turns optimization off. |
| <lToggle> | Turns optimization on if TRUE or off is FALSE. |
| Note: The initial default of this setting depends on the RDD. Check RDDInfo(_SET_OPTIMIZE) to find out the setting for the RDD in use for the current work area. |
Description
For RDDs that support optimization, such as DBFCDX, SET OPTIMIZE determines whether to optimize filters based on the orders open in the current work area. If this flag is ON, the RDD will optimize the search for records that meet the filter condition to the fullest extent possible, minimizing the need to read the actual data from the database file.
If this flag is OFF, the RDD will not optimize.
Assembly
XSharp.RT.DLL
See Also
DbSetFilter(), RDDInfo(), SET FILTER
