-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
QE 2024-03-04, QE 2024-03-18, QE 2024-04-01, QE 2024-04-15, QE 2024-04-29, QE 2024-05-13, QE 2024-05-27, QE 2024-06-10, QE 2024-06-24, QE 2024-07-08, QE 2024-07-22, QE 2024-08-05, QE 2024-08-19, QE 2024-09-02, QE 2024-09-16, QE 2024-09-30, QE 2024-10-14, QE 2024-10-28, QE 2024-11-11, QE 2024-11-25
Initial results from a local prototype: Replacing VM-based aggregation in the SBE HashLookupStage with native C++ aggregation to construct the $lookup output array results in a +62% performance gain as measured by the LookupOnly.yml Genny benchmark. Removing an extraneous $project stage, which this makes possible, boosts this to a +73% gain against existing SBE (and +61% gain against Classic).