Optimizing the sort before the “out-of-memory” Aggregate

<< 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) > 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 clip0122 Sort Action, it’s interesting to place a clip0152 ColumnFilter Action. To have the highest computation speed, you should always reduce to the minimum the volume of data to sort.