11/11/09

Intelligent Calculation Performance Tunning

1. Switch on the Intelligent Calculation. It seems if we switch off Intelligent
Calculation, the calculation result will be correct. Because all of the data blocks no matter if it is marked as dirty or clean will be recalculated. But the price is too many data blocks will be included in calculation.
2. We can switch on and off the intelligent calculation inside Calculation Script in different cases so that only the necessary data blocks are recalculated. Use command: Set CLEARUPDATASTATUS ONLY/AFTER/OFF, SET UPDATECALC ON/OFF
Sample :
SET UPDATECALC OFF;
SET CLEARUPDATESTATUS AFTER;
CALC TWOPASS;