...
Flushing the cache with the above command is safe and 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:, not using any swap, and with 2.7GB size of /path/to/omk/var/ directory:
| opReports 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 |
...