Add support for all type of joins like Postgres has and improve performance
$lookup is a performance killer. Joins are crucial parts in every OLTP system. $lookup is the equivalent to join in SQL, however $lookup is slow, doesn't support hash joins or other efficient join algorithm implemented in Postgres for example.
Seems that if mongo won't add support, their DB puts behind Postgres.
3
votes

-
Tri commented
Hello,
I totally agree, we have customers complaining a lot about this, some starting to use a parallel SQL database, which is the downslope of leaving us.
This is absolutely critical.