Improve performance of blocking sort queries in SBE

XMLWordPrintableJSON

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

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

              Assignee:
              Alberto Massari
              Reporter:
              Ethan Zhang (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

                Created:
                Updated:
                Resolved: