Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-77427

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

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.1.0-rc0, 7.0.9
    • Affects Version/s: None
    • Component/s: None
    • Labels:
    • 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

      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@mongodb.com Ivan Fefer
            Reporter:
            hana.pearlman@mongodb.com Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            15 Start watching this issue

              Created:
              Updated:
              Resolved: