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

3.2.3 performance regression

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.2.3
    • Component/s: Querying
    • None
    • ALL
    • Hide

      See the description above

      Show
      See the description above

      We have optimized core queries to work with few nscanned and low ms. This optimization works in 2.6.11 and 2.4.9.

      However, in 3.2.3 performance regressed badly.

      In 2.6.11 we have,
      "nscanned" : NumberInt(11),
      "nscannedObjects" : NumberInt(10),
      "keyUpdates" : NumberInt(0),
      "numYield" : NumberInt(0),
      "millis" : NumberInt(0)

      In 3.2.3 we have,
      "keysExamined" : NumberInt(10762703),
      "docsExamined" : NumberInt(2208753),
      "numYield" : NumberInt(84084),
      "millis" : NumberInt(33272),

      See the query, indexes, collection statistics and full profiler input in the attached document.

      Note that the documents in the PostKey2 collection are similar to the documents described in SERVER-22872.

            Assignee:
            david.storch@mongodb.com David Storch
            Reporter:
            itwebtf@saxobank.com ITWEBTF SAXOBANK
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: