...
Average query response time is measured in the following way:
Indicator | Value | |||
---|---|---|---|---|
Average query execution time | milliseconds | 0-500 | 501-1999 | 2000+ |
If the average query execution time is higher than 501 milliseconds, it could indicate a fundamental problem with the performance of the database that XperienCentral is using. If other applications are using the same database as XperienCentral, this can cause the average query execution time to increase. If you consistently experience high average query execution times, you should investigate how the database you are using for XperienCentral is configured and whether it is functioning correctly/optimally.
...
The average cache ratio is measured in the following way:
Indicator | Value |
---|
Average cache ratio | percent | 10+ | between 1 and 9 | less than 1 |
A cache ratio that is less than 10 indicates that XperienCentral is having to generate a large number of pages instead of retrieving them from the cache. This can be because:
...