AAALR refers to the average length of the aggregation array. For some customers who have large data sets, poor response times ,and/or complex calculations this warning will present in their logs. The general fix for this is to add this entry to the [Settings 7] portion of the Settings.ini for QlikView Server on all nodes:
This will switch to a new aggregation array which improves performance.
The warning to which you are referring - QVGeneral: when AAALR(1.293973) is greater than 1.000000, we suggest using new row applicator to improve time and mem effeciency. AAALR" is a very low level concept deep in the QlikView engine. Generally speaking it means the average length of aggregation array. The longer this array is, the more RAM usage and CPU power are to be consumed by the engine to get aggregation result for every hypercube node and can thus effect performance.
When AAALR is greater than 1.0, normally the customer has a large data set and suffers slow responses and high memory usage in their app.
To mitigate this, you can add the below setting to the Settings.ini file located in the QlikTech\QlikViewServer:
By setting this parameter to “0”, QlikView will use an new algorithm which is optimized for large data set to do the aggregation, and will consume much less RAM and CPU power.