query slow when searching for 2 identical sub documents

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Done
    • Priority: Minor - P4
    • None
    • Affects Version/s: 2.4.3
    • Component/s: None
    • None
    • Environment:
      win 64
    • Windows
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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

            Assignee:
            David Hows (Inactive)
            Reporter:
            wolf
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: