Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5.5
    • Component/s: Performance
    • Labels:
      None

      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
          xgen-internal-githook 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
          xgen-internal-githook 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@maloon.de Sebastian Paul added a comment -

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

          Show
          sebastian.paul@maloon.de Sebastian Paul added a comment - is it possible that this can be backported to 2.4 stable?
          Hide
          eliot 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 Eliot Horowitz added a comment - Sebastian, no, a backport isn't possible. This relies on the query execution system going in 2.6.
          Hide
          xgen-internal-githook 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
          xgen-internal-githook 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
          xgen-internal-githook 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
          xgen-internal-githook 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:
              37 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since reply:
                1 year, 1 week, 5 days ago
                Date of 1st Reply: