3 ms·
If you try to directly translate SQL to MongoDB, without changing your schemas or query, then yes, it's gonna look bad. That doesn't make for a good comparison,
by 013a 6y ago
If you try to directly translate SQL to MongoDB, without changing your schemas or query, then yes, it's gonna look bad. That doesn't make for a good comparison, and I think you know that.
- lostjohnny 6y ago> That doesn't make for a good comparison, and I think you know that. That query is not my invention, it comes directly from MongoDB documentation If it looks bad, it means it is bad by design https://docs.mongodb.com/manual/reference/operator/aggregation/lookup/#examples https://docs.mongodb.com/manual/reference/operator/aggregati...