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

Improve performance of large $in queries in SBE

XMLWordPrintableJSON

    • Type: Icon: Task Task
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • QE 2022-06-13, QE 2022-06-27, QE 2022-07-11, QE 2022-07-25, QE 2022-08-08, QE 2022-08-22

      The SBE implementation requires an entire $in array to be converted into an internal ArraySet type. This is a costly operation that needs to be performed for each input query, even with enabled auto-parameterization. The new plan cache cannot help here.

      Relevant microbenchmarks:

      • Queries.UnindexedLargeInNonMatching -24.57%
      • Queries.UnindexedVeryLargeInSortedMatching -50.26%
      • Queries.UnindexedLargeInMatching -24.36%

            Assignee:
            backlog-query-execution [DO NOT USE] Backlog - Query Execution
            Reporter:
            ethan.zhang@mongodb.com Ethan Zhang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            17 Start watching this issue

              Created:
              Updated: