4 ms·
Mongo has issues with its query optimizer. I’ve seen this happen before, killing performance. The fix was to give the query a hint on the correct index to use.
by wallflower 8y ago
Mongo has issues with its query optimizer. I’ve seen this happen before, killing performance. The fix was to give the query a hint on the correct index to use.
A similar issue reported
https://jira.mongodb.org/plugins/servlet/mobile#issue/SERVER-13866 https://jira.mongodb.org/plugins/servlet/mobile#issue/SERVER...
- gigatexal 8y agoSo I can see the justification for adding a bit of work to the developer or query writer to pick the right index for the document would mean consistent query performance every time (since it's a document anyway finding the right index should be pretty easy I would imagine). I can see why one would choose this then.