Why Account as Dense and Why not Account as Sparse !!

Summary:

Hi ,

We have created Freeform(Hybrid) application with 11 Dimensions ,where Account as Dense, Period is Dense and remaining all are Sprase. Business Rules are taking longer time than expected here.

So in other environment we have created Account as the Sparse type and Period is Dense , and one other Dimension which is Amount Type made the type as Dense, (in previous instance, Amount type is Sparse having 4 members) remaining all other Dimensions are same between two environments, all the dimension structure and data everything is same,

Same Business Rules are taking very less time compared to Account as Dense.( Example:- 20 Sec in Account as Sparse, 4 mins in Account as Dense).