Performance regression in Queries.FindProjectionDottedField

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Won't Fix
    • Priority: Major - P3
    • None
    • Affects Version/s: 2.6.4
    • Component/s: Querying
    • Fully Compatible
    • ALL
    • Hide

      With a 2.7.1 or greater shell

      var tests=[]
      load ('/home/alvin/mongo-perf-current/util/utils.js')
      tests.push( { name: "Queries.FindProjectionDottedField",
                    pre: function( collection ) {
                        collection.drop();
                        for ( var i = 0; i < 1000; i++ ) {
                            collection.insert( { x : { y: i } } );
                        }
                    },
                    ops: [
                        { op: "find",
                          query: { },
                          filter: { 'x.y' : 1, _id : 0 } }
                    ] } );
      
      Show
      With a 2.7.1 or greater shell var tests=[] load ( '/home/alvin/mongo-perf-current/util/utils.js' ) tests.push( { name: "Queries.FindProjectionDottedField" , pre: function( collection ) { collection.drop(); for ( var i = 0; i < 1000; i++ ) { collection.insert( { x : { y: i } } ); } }, ops: [ { op: "find" , query: { }, filter: { 'x.y' : 1, _id : 0 } } ] } );
    • CAP - 3.1.4
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      2.5.4 introduced a performance regression for Queries.FindProjectionDottedField over 2.4.10 which still exists in 2.6.4.

            Assignee:
            David Daly (Inactive)
            Reporter:
            Alvin Richards (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: