4 ms·
What should be added to this is the ability to tell Mongo to return an error if your query requires a table scan. That one configuration item can be the differe
by dkhenry 14y ago
What should be added to this is the ability to tell Mongo to return an error if your query requires a table scan. That one configuration item can be the difference between a request returning an error and a whole site going down for an extended period.
- lucian1900 14y agoYou can ask it to explain what it did, just like you'd ask for the last error. Then in your app enforce whatever rules related to indexes you wish.
- mattparlane 14y agoexplain actually runs the query. From http://www.mongodb.org/display/DOCS/Explain http://www.mongodb.org/display/DOCS/Explain : Note that explain runs the actual query to determine the result. If the query is slow, the explain will be slow too.
- pbrumm 14y agoThere is a config setting for that notablescan = true http://docs.mongodb.org/manual/reference/configuration-options/ http://docs.mongodb.org/manual/reference/configuration-optio...
- dkhenry 14y agoRight I was saying that the author should add that to his article. Its a very valuable configuration item and anytime your dealing with optimizing indexes its worth enabling.