Troubleshooting Performance Problem in Pivot Grid
When you encounter performance issues such as hanging or unresponsive pages in the Pivot Gird. This is often due to certain properties requiring more computation logic to perform its behavior.
Properties Affecting Performance
The following properties, when enabled, can cause performance delays and even make the web page unresponsive:
- Fit - Content
- Allow Text Wrap
- Allow Column Resize
When these properties are enabled, virtualization is disabled. This means that the entire record will be loaded into the pivot grid on the initial load, which can cause a performance delay due to the calculations being performed on each cell to achieve the expected behavior of these properties.
Recommended Solution
If you are experiencing performance issues and have any of these properties enabled, it is recommended to disable them, especially when using a large number of records.
In addition, you can configure the ‘Content Column Width’ as per your need. This will replace the behavior of fit to content and column resize, and can help improve performance.
Additional Resources
For more information on configuring the pivot grid widget and troubleshooting performance issues, please refer to the following documentation: Pivot Grid Widget Configuration.
If you continue to experience performance issues even after disabling the mentioned properties and adjusting the ‘Content Column Width’, please reach out for further assistance.
References
