Mongo aggregation with mongo lookup is very slow

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Incomplete
    • Priority: Critical - P2
    • None
    • Affects Version/s: None
    • Component/s: Aggregation Framework
    • None
    • ALL
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Use nodejs Mongo driver,

      1. Get a list of keys (3000 keys) through aggregation from one collections.
      2. Use this list to get detail description from another collection.
      3. Project one attribute of detail description.
      4. it takes more than 120 seconds to finish the aggregation.
      5. Use two stage operations (manually join) takes only 900 ms to finish the aggregation.

            Assignee:
            Unassigned
            Reporter:
            Fan Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: