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

What is the current best way to join two collections on mongo?

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • 3.1.0
    • None
    • None

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            siddarthareddyn Siddartha Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: