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

Mongo aggregation with mongo lookup is very slow

XMLWordPrintableJSON

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

      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 Unassigned
            Reporter:
            fzhang Fan Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: