Performance AQ_Statistic_Visualization container

Problem

When using the AQ_Statistic_Process container in combination with the AQ_Statistic_Visualization container you might experience performance problems when using a large number of cases. The performance impact depends on:

• how many cases match the criteria defined in the AQ_Statistic_Process container 
• how many criteria are defined in the AQ_Statistic_Process container. 

The more cases match and the more criteria there are, the more the performance is degraded. The expected symptoms are:

• slow loading time of pages containing one or more AQ_Statistic_Process containers
• memory usage spikes on the server while rendering pages containing one or more AQ_Statistic_Process containers

The memory usage spike is per user session. If the affected pages can be viewed in multiple concurrent user sessions (i.e. not just by an "administrator" user) the memory usage increase should be multiplied by the number of concurrent user sessions rendering the affected pages.

Solution

The performance of this container will be fixed in a next minor release.

In the meantime it is recommended to avoid the following situations:

• using AQ_Statistic_Process containers with very broad search criteria (which are matched by many cases)
• using AQ_Statistic_Process containers on pages that are rendered very often by many concurrent user sessions