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

Improve performance of blocking sort queries in SBE

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 6.2.0-rc0
    • None
    • Fully Compatible
    • QE 2022-09-19, QE 2022-10-03, QE 2022-10-17, QE 2022-10-31
    • 35
    • 15

    Description

      This is a known issue that pertains to sort implementation in SBE. The new plan cache cannot help here.

      Relevant microbenchmarks:

      • Queries.NonCoveredBlockingSortWithIndexToSupportSort -19.74%
      • Queries.CoveredBlockingSort -23.30%

      Attachments

        1. classic100k.svg
          254 kB
        2. classic1k.svg
          465 kB
        3. classiccovered.svg
          543 kB
        4. classicmanyfieldsort.svg
          506 kB
        5. classicnoncovered.svg
          490 kB
        6. classicsort.svg
          560 kB
        7. sbe100k.svg
          200 kB
        8. sbe1k.svg
          510 kB
        9. sbecoveredblocking.svg
          600 kB
        10. sbemanyfieldsort.svg
          555 kB
        11. sbenoncovered.svg
          517 kB
        12. sbesort.svg
          600 kB

        Issue Links

          depends on

          Task - A task that needs to be done. SERVER-68903 Implement SORT_SIMPLE RID optimization in SBE

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-68432 Improve SBE plan for SORT->IXSCAN

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-68471 Omit ProjectStage when possible in makeRecursiveBranchForGenericIndexScan()

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              alberto.massari@mongodb.com Alberto Massari
              ethan.zhang@mongodb.com Ethan Zhang (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: