Implement setParameter to disable $sequentialCache

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • 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: