[SERVER-20861] What is the current best way to join two collections on mongo? Created: 10/Oct/15  Updated: 10/Oct/15  Resolved: 10/Oct/15

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

Type: Question Priority: Major - P3
Reporter: Siddartha Reddy Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

Let's say I have 16 million records on one collection and 48 million records on another collection. All 16 million records are subset of 48 million, what would be the best way of joining these two collections?

Collection A - "ID" | "Column1" | "Column2"
Collection B - "ID" | "Column2" | "Column3"

Reultant Collection : "ID" | "Column1" | "Column2" | "Column3"

Can some one share the most efficient way?

Thanks,
sid



 Comments   
Comment by Stennie Steneker (Inactive) [ 10/Oct/15 ]

Hi Sid,

The SERVER project is for reporting bugs or feature suggestions for the MongoDB server.

For MongoDB-related community support discussion please post on the mongodb-user group or Stack Overflow.

Thanks,
Stephen

Generated at Thu Feb 08 03:55:31 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.