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

Performance Regression in Mongo-perf Commands.DistinctWithIndexAndQuery

    • Type: Icon: Improvement Improvement
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 3.1.7
    • Affects Version/s: None
    • Component/s: Querying
    • Labels:
    • Fully Compatible
    • QuInt 8 08/28/15

      Seeing a regression on wiredTiger and MMAPv1 on Commands.DistinctWithIndexAndQuery on evergreen.

      MMAPv1 results
      WiredTiger results

      Regression starts on commit: f9904bc

      To recreate with mongo-perf:

      python benchrun.py -t 8 -f testcases/*.js --includeFilter Commands.DistinctWithIndexAndQuery --out perf.json
      

      To recreate with the mongo shell:

      pre = function( collection ) {
                  collection.drop();
                  var docs = [];
                  for ( var i = 0; i < 4800; i++ ) {
                      docs.push( { x : 1 } );
                      docs.push( { x : 2 } );
                      docs.push( { x : 3 } );
                  }
                  collection.insert(docs);
                  collection.ensureIndex( { x : 1 } );
              };
      use test0
      pre(db.test)
      benchRun({"ops":[{"op":"command","tags":["distinct","command","core"],"ns":"test0","command":{"distinct":"Commands_DistinctWithIndexAndQuery0","key":"x","query":{"x":1}},"safe":false,"w":0,"j":false,"writeCmd":true}],"seconds":5,"host":"127.0.0.1:27017","parallel":8})
      

            Assignee:
            david.storch@mongodb.com David Storch
            Reporter:
            david.daly@mongodb.com David Daly
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: