gortiz commented on PR #8979:
URL: https://github.com/apache/pinot/pull/8979#issuecomment-1261175557
New results with the last improvements suggested by @Jackie-Jiang:
```
Benchmark (_limit) (_numRows)
(_orderByAlgorithm) (_primaryRepetitions) Mode Cnt Score Error Units
BenchmarkOrderByDescQueries.sortedDesc 101 1500000
naive 1 avgt 5 212.764 ± 22.368 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101 1500000
naive 1000 avgt 5 46.058 ± 2.962 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101 1500000
naive 5000 avgt 5 33.271 ± 5.227 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101 1500000
null 1 avgt 5 10.628 ± 1.358 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101 1500000
null 1000 avgt 5 7.170 ± 0.565 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101 1500000
null 5000 avgt 5 7.007 ± 0.536 ms/op
BenchmarkOrderByDescQueries.sortedDesc 10100 1500000
naive 1 avgt 5 502.738 ± 12.277 ms/op
BenchmarkOrderByDescQueries.sortedDesc 10100 1500000
naive 1000 avgt 5 461.401 ± 19.661 ms/op
BenchmarkOrderByDescQueries.sortedDesc 10100 1500000
naive 5000 avgt 5 381.431 ± 9.761 ms/op
BenchmarkOrderByDescQueries.sortedDesc 10100 1500000
null 1 avgt 5 50.491 ± 6.376 ms/op
BenchmarkOrderByDescQueries.sortedDesc 10100 1500000
null 1000 avgt 5 38.933 ± 5.553 ms/op
BenchmarkOrderByDescQueries.sortedDesc 10100 1500000
null 5000 avgt 5 33.065 ± 1.795 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101000 1500000
naive 1 avgt 5 637.033 ± 11.965 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101000 1500000
naive 1000 avgt 5 528.267 ± 22.312 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101000 1500000
naive 5000 avgt 5 527.354 ± 45.383 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101000 1500000
null 1 avgt 5 52.356 ± 3.886 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101000 1500000
null 1000 avgt 5 47.692 ± 4.879 ms/op
BenchmarkOrderByDescQueries.sortedDesc 101000 1500000
null 5000 avgt 5 37.208 ± 12.339 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101 1500000
naive 1 avgt 5 265.343 ± 16.922 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101 1500000
naive 1000 avgt 5 184.912 ± 8.529 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101 1500000
naive 5000 avgt 5 105.262 ± 5.114 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101 1500000
null 1 avgt 5 53.949 ± 4.434 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101 1500000
null 1000 avgt 5 89.993 ± 31.135 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101 1500000
null 5000 avgt 5 81.264 ± 5.733 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 10100 1500000
naive 1 avgt 5 472.145 ± 16.579 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 10100 1500000
naive 1000 avgt 5 757.835 ± 51.859 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 10100 1500000
naive 5000 avgt 5 762.778 ± 15.560 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 10100 1500000
null 1 avgt 5 100.263 ± 18.075 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 10100 1500000
null 1000 avgt 5 104.300 ± 3.241 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 10100 1500000
null 5000 avgt 5 103.599 ± 9.995 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101000 1500000
naive 1 avgt 5 638.340 ± 62.591 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101000 1500000
naive 1000 avgt 5 941.473 ± 139.675 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101000 1500000
naive 5000 avgt 5 1030.555 ± 12.376 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101000 1500000
null 1 avgt 5 118.147 ± 8.753 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101000 1500000
null 1000 avgt 5 113.684 ± 9.346 ms/op
BenchmarkOrderByDescQueries.sortedDescPartially 101000 1500000
null 5000 avgt 5 121.790 ± 7.841 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: commits-unsubscr...@pinot.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org
