Details
-
Bug
-
Resolution: Done
-
Major - P3
-
None
-
Mongo 3.2.4
*Location*: https://docs.mongodb.org/manual/reference/method/cursor.snapshot/#cursor.snapshot
*User-Agent*: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116 Safari/537.36
*Referrer*: http://webcache.googleusercontent.com/search?q=cache:jBOeYERPFTYJ:docs.mongodb.org/manual/faq/developers+&cd=4&hl=en&ct=clnk&gl=us
*Screen Resolution*: 1600 x 900
*repo*: docs
*source*: reference/method/cursor.snapshot
Mongo 3.2.4 *Location*: https://docs.mongodb.org/manual/reference/method/cursor.snapshot/#cursor.snapshot *User-Agent*: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116 Safari/537.36 *Referrer*: http://webcache.googleusercontent.com/search?q=cache:jBOeYERPFTYJ:docs.mongodb.org/manual/faq/developers+&cd=4&hl=en&ct=clnk&gl=us *Screen Resolution*: 1600 x 900 *repo*: docs *source*: reference/method/cursor.snapshot
Description
Please define if snapshot mode impacts index selection.
Does it use _id index and thus reduce performance by ignoring index that covers the query?
Or does it sort the results in memory after using the same index as in normal mode.
Is snapshot mode equivalent to adding sort({_id:1})?