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

SBE-eligible queries with many predicates multi-plan every time even when SBE is off

    • Type: Icon: Bug Bug
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 8.0.0-rc0, 8.1.0-rc0
    • Component/s: None
    • None
    • Query Execution
    • ALL

      According to comments in the code, we do not use the SBE cache for queries that have more than a certain number of parameters (512).

      This has two issues:

      • These queries now have to multi-plan every time, whereas in classic they would not. While it may be the case that parameterizing is not the right choice for queries like this, from a user's perspective, going from classic to SBE will cause the query to multi-plan every time and possibly regress performance. This is more of a design choice than a code-level issue. SERVER-89436 discusses this problem in detail.
      • It seems like in master we've accidentally made it so queries like this are not cached even when SBE is completely disabled.

       

      This ticket is specifically about fixing the second issue.

            Assignee:
            Unassigned Unassigned
            Reporter:
            ian.boros@mongodb.com Ian Boros
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated: