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

query slow when searching for 2 identical sub documents

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor - P4 Minor - P4
    • None
    • 2.4.3
    • None
    • None
    • win 64
    • Windows

    Description

      got query of type.
      this query runs without outputing a message if primaryWord not equal secondaryWord (the first "B" not same as second "B").
      there's 1000's of combinations in the DB, and only those with both sub documents the same will throw the message/ run slow.
      my workaround: i dont query for these combinations anymore.

      Wed May 01 06:48:28.435 [conn348] query bauhaus.MDocument query: { $and: [

      { _is Deleted: false }

      ,

      { _basedOn: "$system.SearchPhraseCombination" }

      , { _attributes
      : { $elemMatch:

      { _basedOn: "$system.PrimaryWord", _isDeleted: false, _valueText : "B" }

      } }, { _attributes: { $elemMatch:

      { _basedOn: "$system.SecondaryWord", _ isDeleted: false, _valueText: "B" }

      } } ] } ntoreturn:0 ntoskip:0 nscanned:28007
      keyUpdates:0 locks(micros) r:165221 nreturned:0 reslen:20 165ms

      Attachments

        Activity

          People

            david.hows David Hows
            thingo wolf
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: