songwdfu commented on PR #16452:
URL: https://github.com/apache/pinot/pull/16452#issuecomment-3156315349
Several benchmark results showing ~40% query latency reduction when LIMIT is
effective
new
```
Benchmark (_limit) (_numRows)
(_numSegments)
(_query) (_scenario) Mode Cnt Score
Error Units
BenchmarkPartitionedGroupByQueriesSSE.query 10000 15000
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY COUNT(*) EXP(0.0001) avgt 5 195.605 ±
68.389 ms/op
BenchmarkPartitionedGroupByQueriesSSE.query 10000 15000
100 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY COUNT(*) EXP(0.0001) avgt 5 348.517 ±
197.031 ms/op
BenchmarkPartitionedGroupByQueriesSSE.query 10000 15000
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY COUNT(*) EXP(0.0001) avgt 5 821.036 ±
192.112 ms/op
BenchmarkPartitionedGroupByQueriesSSE.query 10000 15000
300 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY COUNT(*) EXP(0.0001) avgt 5 1440.778 ±
289.821 ms/op
```
old
```
Benchmark (_limit) (_numRows)
(_numSegments)
(_query) (_scenario) Mode Cnt Score
Error Units
BenchmarkPartitionedGroupByQueriesSSE.query 10000 15000
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY COUNT(*) EXP(0.0001) avgt 5 495.537 ±
56.197 ms/op
BenchmarkPartitionedGroupByQueriesSSE.query 10000 15000
100 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY COUNT(*) EXP(0.0001) avgt 5 920.710 ±
71.546 ms/op
BenchmarkPartitionedGroupByQueriesSSE.query 10000 15000
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY COUNT(*) EXP(0.0001) avgt 5 1819.569 ±
130.691 ms/op
BenchmarkPartitionedGroupByQueriesSSE.query 10000 15000
300 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY COUNT(*) EXP(0.0001) avgt 5 2735.284 ±
160.252 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]
