Cache $lookup single solution inner queries when sharded

XMLWordPrintableJSON

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

      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
            Reporter:
            Matt Boros
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: