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

Large $elemMatch queries are slow in SBE

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Gone away
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Query Execution
    • ALL
    • QE 2023-02-06, QE 2023-02-20, QE 2023-03-06
    • 5

    Description

      Summary: The performance of $elemMatch in SBE scales very poorly as the number of elements in the query grows, and the regression appears to grow unbounded (as compared with the classic engine.

      Attachments

        Activity

          People

            martin.neupauer@mongodb.com Martin Neupauer
            kyle.suarez@mongodb.com Kyle Suarez
            Votes:
            0 Vote for this issue
            Watchers:
            14 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: