[DRIVERS-303] Mongo Query Taking Lot of Time Selecting Index Created: 26/May/16  Updated: 30/Aug/16  Resolved: 30/Aug/16

Status: Closed
Project: Drivers
Component/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: arpit wanchoo Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Ubuntu 12
Mongo Version : 3.0.4


Issue Links:
Duplicate
is duplicated by SERVER-24312 Mongo Query Taking Lot of Time Select... Closed

 Description   

There are two issues happening :
First Issue : Query taking lot of time in deciding which index to use.
Eg: If we run an query X , then it takes a lot of time (more than 5 minutes) )and on checking the log it was using a index Y.
Now if I run the query X with index hint Y, it runs in couple of seconds.
That means the time it was taking is not in query execution but before that. Very strange

Second Issue : In some cases it is not selecting the right index also. If my query is on fields A,B,C and I have indexes A and A_B_C created, then it is choosing the index A instead if A_B_C



 Comments   
Comment by Bernie Hackett [ 30/Aug/16 ]

Duplicate of SERVER-24312

Generated at Thu Feb 08 08:21:13 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.