Performance Recommendations for Derived Fields
To improve performance in applications that use derived fields, follow these recommendations:
• Use aggregates primarily to derive table field aggregates of approximately 50 rows or less.
• Avoid deep nesting of dependencies; that is, do not create a derivation formula where Field_A depends on Field_B, which depends on Field_C, and so forth.