Optimize Property (Visual FoxPro)

  • [アーティクル]

Specifies whether the Grid control uses Rushmore optimization. Read/write at design time and run time.

Grid.Optimize [ = lExpr]

Return Value

  • lExpr
    Logical expression specifying if the Grid control uses Rushmore optimization.

    Setting Description

    True (.T.)

    The Grid control uses Rushmore optimization.

    False (.F.)

    (Default) The Grid control does not use Rushmore optimization.

Remarks

Applies To: Grid Control

When Rushmore Optimization is enabled by setting the Optimize property to True (.T.), the set of matched records is refreshed during the following operations:

  • When the Grid is initially populated

  • When the Grid is activated

  • When the Grid Refresh Method is called

Note

As with any data manipulation command that can impact Rushmore optimization, you should be aware that actions taken against the Grid's data source could result in behavior that differs from when the Optimize property is set to False (.F.). For example, Rushmore optimization might trigger an implicit TABLEUPDATE to occur for a row buffered cursor. And an error may or may not occur depending on whether the record is blank or whether the cursor is a view.

See Also

Reference

SYS(3054) - Rushmore Query Optimization Level
SET OPTIMIZE Command

Concepts

Using Rushmore Query Optimization to Speed Data Access