richardstartin commented on PR #8764:
URL: https://github.com/apache/pinot/pull/8764#issuecomment-1135992511
This leads to a modest improvement, which would improve when the filter
can't be inlined, and if the filter were implemented in a branch-free style
```
Benchmark (_numRows)
(_query) (_scenario) Mode Cnt Score Error Units
BenchmarkQueries.query 1500000 SELECT SUM(RAW_INT_COL) FROM MyTable
WHERE RAW_INT_COL BETWEEN 1 AND 10 EXP(0.001) avgt 5 13.447 ± 1.817
ms/op
BenchmarkQueries.query 1500000 SELECT SUM(RAW_INT_COL) FROM MyTable
WHERE RAW_INT_COL BETWEEN 1 AND 10 EXP(0.5) avgt 5 30.589 ± 0.710
ms/op
BenchmarkQueries.query 1500000 SELECT SUM(RAW_INT_COL) FROM MyTable
WHERE RAW_INT_COL BETWEEN 1 AND 10 EXP(0.999) avgt 5 25.331 ± 2.261
ms/op
Benchmark (_numRows)
(_query) (_scenario) Mode Cnt Score Error Units
BenchmarkQueries.query 1500000 SELECT SUM(RAW_INT_COL) FROM MyTable
WHERE RAW_INT_COL BETWEEN 1 AND 10 EXP(0.001) avgt 5 16.033 ± 5.131
ms/op
BenchmarkQueries.query 1500000 SELECT SUM(RAW_INT_COL) FROM MyTable
WHERE RAW_INT_COL BETWEEN 1 AND 10 EXP(0.5) avgt 5 36.588 ± 1.894
ms/op
BenchmarkQueries.query 1500000 SELECT SUM(RAW_INT_COL) FROM MyTable
WHERE RAW_INT_COL BETWEEN 1 AND 10 EXP(0.999) avgt 5 31.201 ± 3.927
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]
