Details
-
Task
-
Resolution: Fixed
-
Major
-
6.5.0
Description
Q1 uses a request of the form
select * from default use keys [$1]
If I change the request to ... use keys $1, on my little performance testbed throughput improves from 15500 req/sec to 16700 (a good 8%).
While we should change Q1 on perfrunner, we should also make scanning the array faster in the key scan operator.
Attachments
For Gerrit Dashboard: MB-31563 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
101446,3 | MB-31563 improve use keys [] | master | query | Status: MERGED | +2 | +1 |
101481,3 | MB-31563 improve use keys [] | master | query | Status: MERGED | +2 | +1 |