...
- A new option 'opreports_do_cache_known_reports' in /path/to/omk/conf/opCommon.nmis determines whether this cache is enabled or disabled. The cache is enabled by default since opReports 3.1.11.
- Testing on a server with a moderateley large number of generated reports has found load time to view a large report improves from more than 9 minutes to less than 45 seconds with the cache enabled.
...
Flushing the cache with the above command may also be useful in problem-solving.
The performance of the opReports known_reports_cache can be summarised as follows when checked on a virtual server with 4 CPUs , 16GB of RAM and no use of swap:
Page Loaded | Time to load without known_reports_cache (seconds) | Time to load with known_reports_cache (seconds) |
---|---|---|
Dashboard | 15.53 | 16.52 |
Operational Status | 40.27 | 15.36 |
Report Schedules | 17.56 | 3.29 |
Saved Reports | 26.01 | 13.48 |
Opening grouped_capacity Report within Saved Reports Page | 864 | 25.23 |
On-Demand Reports | 18.24 | 3.33 |
Opening grouped_capacity Report within On-Demand Reports Page | 954 | 25.43 |