3 ms·
Not only that, they're projections which you don't have to spend effort on keeping up to date, and which the engine automatically uses to optimize your queries.
by throwanem 10y ago
Not only that, they're projections which you don't have to spend effort on keeping up to date, and which the engine automatically uses to optimize your queries. While there's an argument to be made that the same can be accomplished in a non-relational database with suitable application code or a translation layer, all else equal it's better not to need those things in the first place.
- phamilton 10y agoAnd as we saw from a recent Uber post about Postgresql, that automatic updating is not actually free.
- hobs 10y agoWas going to say the same, but I realized the OP was talking about in your code, not so much as overhead.
- throwanem 10y agoOf course it's not, but if you're not Uber, that almost certainly isn't a problem for you. When you use MongoDB, you get to roll your own indexes no matter who you are.