Optimize analytics performance
Veracode Analytics uses the Looker platform for data analytics, dashboards and visualizations. Dashboards may take a long time to load when their SQL queries take longer to run. In addition, some components can consume significant memory, leading to performance issues.
To optimize the performance of Veracode Analytics, follow these best practices for creating and using dashboards:
- Avoid displaying too much data in a single dashboard element. This reduces memory usage and improves performance.
- Limit the number of elements in a dashboard. This reduces the number of queries run when the dashboard loads.
- If a dashboard uses only filters, disable Run on load.
- Use required filters wherever possible.
- Remember that post-query processing features, such as merged results, custom fields, and table calculations, consume memory.
- Because pivoted dimensions increase processing load, filter at the dashboard or Look level to allow the user to select the dimension values that they are most interested in comparing.
- Aim to have fewer columns and rows to improve browser performance.
- Use filters at the dashboard or Look level to reduce the number of results displayed in each element.
To quickly create a report for any set of data, use the reporting API.
The following resources provide best practices for building and optimizing Looker dashboards: