Avoid going through the network when a shard is targeting only itself for a $lookup subpipeline

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Major - P3
    • 7.1.0-rc0, 7.0.9
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • Fully Compatible
    • v7.0, v6.0
    • QO 2023-06-12, QO 2023-06-26, QO 2023-07-10, QO 2023-08-07
    • 135
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      This is meant to be a targeted improvement specific to $lookup, though depending on the implementation it could affect other commands which use sharded_agg_helpers::attachCursorToPipeline, similar to SERVER-58376. When this work is done, we would expect to see improvement especially for $lookups where the local and foreign data is co-located (see workloads from PERF-4152)

              Assignee:
              Ivan Fefer
              Reporter:
              Hana Pearlman
              Votes:
              0 Vote for this issue
              Watchers:
              16 Start watching this issue

                Created:
                Updated:
                Resolved: