[SERVER-13139] Performance regression with smaller $in queries Created: 11/Mar/14 Updated: 11/Jul/16 Resolved: 13/Mar/14 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 2.6.0-rc1 |
| Fix Version/s: | 2.6.0-rc2 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ben Becker | Assignee: | Benety Goh |
| Resolution: | Done | Votes: | 0 |
| Labels: | 26qa | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||||||||||
| Issue Links: |
|
||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||
| Operating System: | ALL | ||||||||||||||||
| Participants: | |||||||||||||||||
| Description |
|
100-element $in queries appear to be an order of magnitude slower in v2.6.0-rc1 (even with lower_bound patch) than in v2.4.9: Using the attached code: v2.4.9:
RC1:
RC1 with binary search
RC1 with lower_bound:
|
| Comments |
| Comment by Githook User [ 13/Mar/14 ] | ||||||||||||||||||||||||||||||
|
Author: {u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}Message: | ||||||||||||||||||||||||||||||
| Comment by Githook User [ 13/Mar/14 ] | ||||||||||||||||||||||||||||||
|
Author: {u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}Message: | ||||||||||||||||||||||||||||||
| Comment by Githook User [ 13/Mar/14 ] | ||||||||||||||||||||||||||||||
|
Author: {u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}Message: | ||||||||||||||||||||||||||||||
| Comment by Githook User [ 13/Mar/14 ] | ||||||||||||||||||||||||||||||
|
Author: {u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}Message: | ||||||||||||||||||||||||||||||
| Comment by Ben Becker [ 11/Mar/14 ] | ||||||||||||||||||||||||||||||
|
in_query_100.svg contains 10 consecutive executions of the attached script against current master (097f38faf2856f7776c75a48d985b6b3f1641860) with the lower_bound patch included.
|