Page History
...
| Info |
|---|
This recommendation applies to functions eachMember(), membersSum(), membersAvg(), membersMin() and membersMax(). |
The common principle of these functions is iterating over the desired attribute values. E.g. eachMember('L_CITY') { ... } iterates over cities contained in the source data set. If there are N unique cities, the loop is executed N times. Depending on the hardware configuration, execution of one of these function is very demanding and affects the performance of the entire system if not used properly. The main criterion is how many times is the loop executed, in other words, how many unique entries does the chosen attribute have. According to our best practices and feedback from customers, the correct usage should follow this matrix:
...
The conclusion derived from the matrix above is, that these functions should be used in combination with maximum 100.000 unique attribute values. For larger amount of data users may want to use the BellaDati-R module, which is coming in Q2/2016.
| Tip |
|---|
For some use cases, consider using forEachRow() instead of looping functions. |
Overview
Content Tools