Implement setParameter to disable $sequentialCache

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • None
    • 3
    • TBD
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      The $sequentialCache stage (DocumentSourceSequentialDocumentCache) is used within a $lookup sub-pipeline to avoid repetitive computation of intermediate result sets for non-correlated pipeline prefixes.

      We've found a case in which it can interfere with other pipeline optimizations: see related ticket SERVER-106505. In order to work around this problem, we should introduce a query knob which when enabled, turns off the $sequentialCache optimization for all queries. It should be a runtime-settable boolean setParameter called internalDocumentSourceLookupDisableSequentialCache.

              Assignee:
              Unassigned
              Reporter:
              David Storch
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated: