<< Click to Display Table of Contents >> Navigation:  5. Detailed description of the Actions > 5.5. Standard > 5.5.5. Aggregate (Group by) (High-Speed action) > 5.5.5.2. Optimizing the sort before the “out-of-memory” Aggregate

 

Let’s assume that we have:

 

 

In such situation, we can do the following:

 

To compute the above aggregate, we only need to sort a table with the A and B columns only (and not the whole table, with all the columns). Thus, before the Sort Action, it’s interesting to place a ColumnFilter Action. To have the highest computation speed, you should always reduce to the minimum the volume of data to sort.