Admins can now control caching for individual reports in the report settings.
- Go to Reports > All Reports, and double-click the report to edit.
- Go to the Settings tab.
- Expand the Advanced Settings for the report.
- Configure the following options to control the report cache:
Enable Report Filter Caching
Select to accelerate processing speed when generating multiple reports. In this case, all filters are applied when querying the hcache table. This is the default.
De-select to improve report accuracy. In this case, the filters are put inside the hcache to increase data accuracy. However, this will also impact performance.
Enable High Accuracy Caching
Select to increase the maximum hcache rows, increasing data accuracy.
You can show, set, or reset the maximum number of rows for high-accuracy hcache by entering the following command in the FortiAnalyzer CLI:
diagnose sql config hcache-max-high-accu-row [reset | set <integer>]
De-select to use the default number of hcache rows, increasing system performance. This is the default.
You can show, set, or reset the default number of hcache rows by entering the following command in the FortiAnalyzer CLI:
diagnose sql config hcache-max-rpt-row [reset | set <integer>]
- Click Apply to save the changes.