Performance FAQs
Can Holistics Reports work with large volumes of data?
To answer this question, let's look at this simplified flow of a single Report execution:
- Holistics does not have any constraint on the amount of data on your Data Warehouse.
- Your Data Warehouse can have billions of rows or more, per its own capacity and capabilities.
- Thus, Holistics can technically work with any amount of data on the Data Warehouse.
- In the SQL execution step:
- Holistics only fetches 1 million rows (at maximum) from the SQL result.
- To learn more about this limit, please refer to the Default Limits
- To reduce the default limit to better control report performance, go to Admin Settings -> Visualization -> Default Records Limit
- The speed of this step depends mostly on the speed of your Data Warehouse.
- Holistics only fetches 1 million rows (at maximum) from the SQL result.
- When fetching data from Holistics Worker to the browser:
- For table-like visualizations (e.g. Data Table, Pivot Table):
- Holistics automatically apply pagination where applicable, so that it efficiently fetches and renders necessary data only.
- For non-table visualizations (e.g. Column Chart, Pie Chart):
- It can get slower when there are more data points to visualize (e.g. > 10K rows/data points), as it negatively affects the browser performance.
- In general, having fewer data points in charts will make them faster and more usable/readable to end-users.
- For table-like visualizations (e.g. Data Table, Pivot Table):
Related resources
Click here to see the central page of Performance Guides.