-
Type:
Question
-
Resolution: Done
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
-
Environment:Linux
-
None
-
3
-
None
-
None
-
None
-
None
-
None
-
None
I have a capped collection with 1.3 million documents indexed on id.
When i do a query with a filter it takes more than 1 minute to give back the result. The query includes find with sort on id and limit(20).
I need to get back the query result in max 30-45 seconds.
Let me know what enhancements can be done.
Below is explain output from shell. Same query i use from perl driver
{
"cursor" : "BtreeCursor _id_ reverse",
"isMultiKey" : false,
"n" : 0,
"nscannedObjects" : 1308194,
"nscanned" : 1308194,
"nscannedObjectsAllPlans" : 2616388,
"nscannedAllPlans" : 2616388,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 72,
"nChunkSkips" : 0,
"millis" : 109349,
"indexBounds" : {
"_id" : [
[
{
"$maxElement" : 1
},
{
"$minElement" : 1
}
]
]
},
Thanks