richardstartin commented on PR #8759:
URL: https://github.com/apache/pinot/pull/8759#issuecomment-1135799798
Regarding performance, there's likely to be about 25% improvement here, but
it's not that widely applicable because the number of cases where `applyAnd` is
called is quite small:
```
Benchmark (_numRows)
(_query) (_scenario) Mode Cnt Score Error
Units
BenchmarkQueries.query 1500000 SELECT RAW_INT_COL FROM MyTable WHERE
INT_COL = 1 AND RAW_INT_COL IN (0, 1, 2) EXP(0.001) avgt 5 1.866 ±
1.525 ms/op
BenchmarkQueries.query 1500000 SELECT RAW_INT_COL FROM MyTable WHERE
INT_COL = 1 AND RAW_INT_COL IN (0, 1, 2) EXP(0.5) avgt 5 16.552 ±
4.065 ms/op
BenchmarkQueries.query 1500000 SELECT RAW_INT_COL FROM MyTable WHERE
INT_COL = 1 AND RAW_INT_COL IN (0, 1, 2) EXP(0.999) avgt 5 14.501 ±
3.665 ms/op
Benchmark (_numRows)
(_query) (_scenario) Mode Cnt Score Error
Units
BenchmarkQueries.query 1500000 SELECT RAW_INT_COL FROM MyTable WHERE
INT_COL = 1 AND RAW_INT_COL IN (0, 1, 2) EXP(0.001) avgt 5 1.648 ±
0.434 ms/op
BenchmarkQueries.query 1500000 SELECT RAW_INT_COL FROM MyTable WHERE
INT_COL = 1 AND RAW_INT_COL IN (0, 1, 2) EXP(0.5) avgt 5 12.627 ±
0.410 ms/op
BenchmarkQueries.query 1500000 SELECT RAW_INT_COL FROM MyTable WHERE
INT_COL = 1 AND RAW_INT_COL IN (0, 1, 2) EXP(0.999) avgt 5 12.075 ±
0.872 ms/op
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
