Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Major - P3 Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5.5
    • Component/s: Performance
    • Labels:
      None
    • Backport:
      No
    • # Replies:
      21
    • Last comment by Customer:
      true

      Description

      Right now distinct will pull data out of indexes, but will scan the entire thing.
      Can skip whole regions where the key is the same

      Correct way to implement is probably adding a method to a btree bucket like

      getDisinctKeys( int keyOffset )

        Issue Links

          Activity

          Hide
          Githook User
          added a comment -

          Author:

          {u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'}

          Message: SERVER-2094 fast distinct when field is indexed and query is fully covered
          Branch: master
          https://github.com/mongodb/mongo/commit/05db1ea493f0bb00215e0dd94988f9aa927925bc

          Show
          Githook User
          added a comment - Author: {u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'} Message: SERVER-2094 fast distinct when field is indexed and query is fully covered Branch: master https://github.com/mongodb/mongo/commit/05db1ea493f0bb00215e0dd94988f9aa927925bc
          Hide
          Sebastian Paul
          added a comment -

          is it possible that this can be backported to 2.4 stable?

          Show
          Sebastian Paul
          added a comment - is it possible that this can be backported to 2.4 stable?
          Hide
          Eliot Horowitz
          added a comment -

          Sebastian, no, a backport isn't possible. This relies on the query execution system going in 2.6.

          Show
          Eliot Horowitz
          added a comment - Sebastian, no, a backport isn't possible. This relies on the query execution system going in 2.6.
          Hide
          Githook User
          added a comment -

          Author:

          {u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'}

          Message: SERVER-10026 SERVER-13271 SERVER-12878 SERVER-2094 avoid surplus projections in distinct
          Branch: master
          https://github.com/mongodb/mongo/commit/267f56a7e0ce36eba21b4b2ef09e32a43370acbf

          Show
          Githook User
          added a comment - Author: {u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'} Message: SERVER-10026 SERVER-13271 SERVER-12878 SERVER-2094 avoid surplus projections in distinct Branch: master https://github.com/mongodb/mongo/commit/267f56a7e0ce36eba21b4b2ef09e32a43370acbf
          Hide
          Githook User
          added a comment -

          Author:

          {u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'}

          Message: SERVER-10026 SERVER-13271 SERVER-12878 SERVER-2094 avoid surplus projections in distinct
          Branch: v2.6
          https://github.com/mongodb/mongo/commit/094f1565d6f82859bc38300b45564dd1ea9f070e

          Show
          Githook User
          added a comment - Author: {u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'} Message: SERVER-10026 SERVER-13271 SERVER-12878 SERVER-2094 avoid surplus projections in distinct Branch: v2.6 https://github.com/mongodb/mongo/commit/094f1565d6f82859bc38300b45564dd1ea9f070e

            People

            • Votes:
              31 Vote for this issue
              Watchers:
              39 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since reply:
                4 weeks, 1 day ago
                Date of 1st Reply: