Optimizing Performance and Managing Limits in the Pivot Grid
The Pivot Grid widget is a powerful tool for data analysis and visualization, but it does come with certain limitations that users should be aware of to ensure optimal performance and usability.
Record Limitations
The Pivot Grid widget can fetch a maximum of 50,000 records. This limitation is crucial for maintaining performance and ensuring that the widget operates smoothly.
Performance Considerations for Pivot Widget:
When dealing with datasets that approach the maximum record limit, users may experience performance delays. These delays can manifest as slower loading times or lag in interactivity within the widget. To mitigate these issues, consider the following best practices:
- Data Filtering: Apply filters to reduce the number of records being processed.
- Data Aggregation: Summarize data before loading it into the Pivot Grid to minimize the volume of records.
- Incremental Loading: If possible, load data in smaller increments rather than all at once.
By adhering to these practices, users can enhance the performance of the Pivot Grid widget and ensure a smoother experience when analyzing data.
Export Limitations
In version 7.10 and later, support was introduced to increase the limit for exporting data from the Pivot Grid Widget. While this enhancement allows for the export of larger datasets, it is important to note that increasing the export limit may lead to performance delays.
Configuring Export Limits
To adjust the export limit for the Pivot Grid Widget, users can modify the config.json file. This file is accessible through the settings page of the application. Here are the steps to change the limit:
-
Navigate to the
UMS(User Management System) page. -
Click on the
Settingspage. -
Select
Configuration Settings. -
Choose the
config.jsonfile to make the necessary adjustments."Pivot": { "MaxRecordCount": 50000 },
The maximum record count can be modified as needed; in this case, I have increased it by an additional 10,000 records.
By following these steps, users can customize the export limit according to their specific needs while being mindful of the potential impact on performance.
Additional References
