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

Improve performance of blocking sort queries in SBE

XMLWordPrintableJSON

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
    • Fully Compatible
    • QE 2022-09-19, QE 2022-10-03, QE 2022-10-17, QE 2022-10-31
    • 35
    • 15

      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%

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

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

              Created:
              Updated:
              Resolved: