-
Type: Bug
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: 2.6.5
-
Component/s: Querying
-
None
-
ALL
when same query and index run on 2.6.4 it is much faster then on 2.6.5 , looking at explain show second scan to not use the indexes.
the attached js file has both query and explain results for both versions, can see millis difference . 150015 on 2.6.5 compared to 0 on 2.6.4 server.
follow is [ObjectId()]
query use $in and $nin .
the affect is noticed when users is more then 110000 documents on a server with 1GB RAM.
- related to
-
SERVER-14618 Wrong index bounds when using "hint"
- Closed
-
SERVER-15279 Disable hash-based index intersection (AND_HASH) by default
- Closed