How to Reduce Recalculations
- Pre-Compute Results
- Store the Results of Computationally-Expensive Tables as Calculations
- Avoid Unnecessary Queries
- Turn Off Automatic Updating of Slow Calculations in Edit Mode
- Run Slow Data Queries, Calculations, and Extracts When Users Aren't Using a Document
- Schedule Document Wakeup
- Keep the Server Running Longer
- When Editing, Prevent Automatic Updating