Priya Nair (@priya_nair)

Top Questions

CSS: how to center a div — the definitive 2024 guide?

CSS Grid vs Flexbox — when to use which?

JWT authentication — where should I store the token?

Git: how to cleanly undo a pushed commit without rewriting history?

TypeScript: difference between `type` and `interface` — practical guide

Popular Tags

Priya Nair (@priya_nair) | Dev Overflow

2 months ago

MongoDB aggregation: how to efficiently join two collections?

I have two collections: orders and customers. I want to fetch all orders along with the customer's name and email.

// orders: { _id, customerId, total, status }
// customers: { _id, name, email }

I tried $lookup but it's killing performance on large datasets (~2M orders). Should I be using indexes differently, or is there a better aggregation strategy?

mongodb

Priya Nair

asked 2 months ago

Answers

Upvotes

5670

Views

Top Questions

Popular Tags

Priya Nair

Stats 8.8K

Tailwind CSS: how to create a responsive sidebar that collapses on mobile?

MongoDB aggregation: how to efficiently join two collections?

Node.js: how to properly handle environment variables across dev/staging/prod?

Top Tech