[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" Reultant Collection : "ID" | "Column1" | "Column2" | "Column3" Can some one share the most efficient way? Thanks, |
| 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, |