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

Cache $lookup single solution inner queries when sharded

    • Type: Icon: Improvement Improvement
    • Resolution: Won't Fix
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • QO 2024-02-05

      In SERVER-75506, caching single solution queries on the inner side of a non-sharded $lookup lead to a positive performance impact. This could have a positive impact on sharded lookup as well, but some performance investigation should be done first.

      For this ticket we should implement this change for sharded $lookup, analyze the perf impact, and make a decision about whether to commit it or not.

            Assignee:
            hana.pearlman@mongodb.com Hana Pearlman
            Reporter:
            matt.boros@mongodb.com Matt Boros
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: