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

Performance issues with distinct and count queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Gone away
    • 2.4.4
    • None
    • Performance
    • None
    • ALL

    Description

      Some types of queries are slower in 2.4.4 than in builds from the 2.2 series. This slowdown is most evident in Windows builds, but may affect other platforms as well.

      This table shows version 2.2.4 versus version 2.4.4 for three sample queries. The values are query durations scaled to the time taken by the query on version 2.2.4 in order to hide differences between queries, platforms and hardware (so 2.2.4 is always 100%). Numbers above 100% indicate a slowdown between versions.

      Platform and version Query 1 Query 2 Query 3
      Windows 2.2.4 100.00% 100.00% 100.00%
      Windows 2.4.4 134.75% 138.87% 137.01%
      Ubuntu 2.2.4 100.00% 100.00% 100.00%
      Ubuntu 2.4.4 109.45% 107.50% 121.55%

      Attachments

        Issue Links

          Activity

            People

              asya.kamsky@mongodb.com Asya Kamsky
              tad Tad Marshall
              Votes:
              7 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: