By default, Our Syncfusion Pivot Table render by framing all the available fields from the bound data source even through using the virtual scrolling and data compression features. This is how our pivot table's current architecture works. Because of considering all the available fields from the given data source for pivot table aggregation during engine population. It can lead to performance constrain, especially when dealing with more number of fields along with a large number of data counts.
Requirement:
To overcome this performance constrain, it is necessary to optimize to the field list formation based on the fields that bound in the pivot table report alone, instead of considering all the fields available in the given data source, that only required for the pivot table rendering. The rest of the field's information, on the other hand, will be framed dynamically as it is added to the report settings at runtime.
Need to consider this optimization for the following use cases/feature:
- Field list formation should only be considered based on the current report settings.
- While creating calculated field with formula using existing fields from the given data source should be considered during field list formation even if it is not added to the report directly.
- If any field is added to the report at runtime, field list information should be updated for the specific field only, where the existing information for the rest of the fields is maintained and doesn't require reframing.
- Above optimization should be considered for pivot table when with and without virtualization, paging, data compression.
Bold BI
Bold Reports
BoldDesk