35 Optimizing Calculations

You can configure a database to optimize calculation performance. The information in this chapter applies only to block storage databases and is not relevant to aggregate storage databases.

• Designing for Calculation Performance

• Monitoring and Tracing Calculations

• Using Simulated Calculations to Estimate Calculation Time

• Estimating Calculation Effects on Database Size

• Using Formulas

• Using Bottom-Up Calculation

• Hybrid Mode in Block Storage Databases

• Managing Caches to Improve Performance

• Working with the Block Locking System

• Using Two-Pass Calculation

• Choosing Between Member Set Functions and Performance

• Consolidating #MISSING Values

• Removing #MISSING Blocks

• Identifying Additional Calculation Optimization Issues