[SERVER-24857] Mongo aggregation with mongo lookup is very slow Created: 30/Jun/16  Updated: 06/Sep/16  Resolved: 06/Sep/16

Status: Closed
Project: Core Server
Component/s: Aggregation Framework
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical - P2
Reporter: Fan Zhang Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Participants:

 Description   

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.



 Comments   
Comment by Kelsey Schubert [ 06/Sep/16 ]

Hi fzhang,

We haven’t heard back from you for some time, so I’m going to mark this ticket as resolved. If this is still an issue for you, please provide additional information and we will reopen the ticket.

Regards,
Thomas

Comment by Kelsey Schubert [ 01/Aug/16 ]

Hi fzhang,

We still need additional information to diagnose the problem. If this is still an issue for you, would you please answer Ramon's questions?

Thank you,
Thomas

Comment by Ramon Fernandez Marina [ 05/Jul/16 ]

fzhang, I'm afraid we'll need some more information to make this ticket actionable:

  • Do you have sample code and data that you can share so we can reproduce this behavior on our end?
  • Do the server logs provide any additional information?
  • What storage engine are you using?
  • What indexes do you have in the specific collections?
  • Is the behavior repeatable?

Thanks,
Ramón.

Comment by Fan Zhang [ 30/Jun/16 ]

Nodejs Mongo driver is 2.1.0

Mongo server version is 3.2.6

Generated at Thu Feb 08 04:07:36 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.