clintropolis commented on PR #12277: URL: https://github.com/apache/druid/pull/12277#issuecomment-1207758927
Repeated the benchmarks after all of the latest changes (and with a newer laptop): ``` Benchmark (query) (rowsPerSegment) (storageType) (stringEncoding) (vectorize) Mode Cnt Score Error Units SqlBenchmark.querySql 4 5000000 mmap none false avgt 5 89.150 ± 1.702 ms/op SqlBenchmark.querySql 4 5000000 mmap none force avgt 5 44.945 ± 1.342 ms/op SqlBenchmark.querySql 4 5000000 mmap fc4 false avgt 5 94.856 ± 2.851 ms/op SqlBenchmark.querySql 4 5000000 mmap fc4 force avgt 5 45.070 ± 1.284 ms/op SqlBenchmark.querySql 4 5000000 mmap fc16 false avgt 5 110.207 ± 1.283 ms/op SqlBenchmark.querySql 4 5000000 mmap fc16 force avgt 5 44.848 ± 1.256 ms/op SqlBenchmark.querySql 5 5000000 mmap none false avgt 5 23.684 ± 0.732 ms/op SqlBenchmark.querySql 5 5000000 mmap none force avgt 5 22.080 ± 0.538 ms/op SqlBenchmark.querySql 5 5000000 mmap fc4 false avgt 5 23.777 ± 0.684 ms/op SqlBenchmark.querySql 5 5000000 mmap fc4 force avgt 5 22.097 ± 0.706 ms/op SqlBenchmark.querySql 5 5000000 mmap fc16 false avgt 5 23.636 ± 0.531 ms/op SqlBenchmark.querySql 5 5000000 mmap fc16 force avgt 5 22.086 ± 0.314 ms/op SqlBenchmark.querySql 6 5000000 mmap none false avgt 5 48.608 ± 1.382 ms/op SqlBenchmark.querySql 6 5000000 mmap none force avgt 5 23.353 ± 0.778 ms/op SqlBenchmark.querySql 6 5000000 mmap fc4 false avgt 5 48.993 ± 1.830 ms/op SqlBenchmark.querySql 6 5000000 mmap fc4 force avgt 5 23.422 ± 0.720 ms/op SqlBenchmark.querySql 6 5000000 mmap fc16 false avgt 5 48.759 ± 1.161 ms/op SqlBenchmark.querySql 6 5000000 mmap fc16 force avgt 5 23.414 ± 0.689 ms/op SqlBenchmark.querySql 7 5000000 mmap none false avgt 5 97.440 ± 2.358 ms/op SqlBenchmark.querySql 7 5000000 mmap none force avgt 5 51.781 ± 1.353 ms/op SqlBenchmark.querySql 7 5000000 mmap fc4 false avgt 5 98.475 ± 2.368 ms/op SqlBenchmark.querySql 7 5000000 mmap fc4 force avgt 5 55.707 ± 1.319 ms/op SqlBenchmark.querySql 7 5000000 mmap fc16 false avgt 5 97.376 ± 1.916 ms/op SqlBenchmark.querySql 7 5000000 mmap fc16 force avgt 5 52.425 ± 1.243 ms/op SqlBenchmark.querySql 8 5000000 mmap none false avgt 5 994.261 ± 31.291 ms/op SqlBenchmark.querySql 8 5000000 mmap none force avgt 5 234.962 ± 3.665 ms/op SqlBenchmark.querySql 8 5000000 mmap fc4 false avgt 5 888.204 ± 14.472 ms/op SqlBenchmark.querySql 8 5000000 mmap fc4 force avgt 5 326.832 ± 5.491 ms/op SqlBenchmark.querySql 8 5000000 mmap fc16 false avgt 5 884.488 ± 17.084 ms/op SqlBenchmark.querySql 8 5000000 mmap fc16 force avgt 5 343.231 ± 3.119 ms/op SqlBenchmark.querySql 10 5000000 mmap none false avgt 5 427.763 ± 9.299 ms/op SqlBenchmark.querySql 10 5000000 mmap none force avgt 5 243.373 ± 5.585 ms/op SqlBenchmark.querySql 10 5000000 mmap fc4 false avgt 5 431.947 ± 14.357 ms/op SqlBenchmark.querySql 10 5000000 mmap fc4 force avgt 5 263.433 ± 4.579 ms/op SqlBenchmark.querySql 10 5000000 mmap fc16 false avgt 5 453.223 ± 14.885 ms/op SqlBenchmark.querySql 10 5000000 mmap fc16 force avgt 5 294.433 ± 8.517 ms/op SqlBenchmark.querySql 11 5000000 mmap none false avgt 5 436.453 ± 10.379 ms/op SqlBenchmark.querySql 11 5000000 mmap none force avgt 5 254.202 ± 3.999 ms/op SqlBenchmark.querySql 11 5000000 mmap fc4 false avgt 5 481.164 ± 18.303 ms/op SqlBenchmark.querySql 11 5000000 mmap fc4 force avgt 5 282.568 ± 3.998 ms/op SqlBenchmark.querySql 11 5000000 mmap fc16 false avgt 5 496.435 ± 12.862 ms/op SqlBenchmark.querySql 11 5000000 mmap fc16 force avgt 5 315.195 ± 6.486 ms/op SqlBenchmark.querySql 12 5000000 mmap none false avgt 5 42.372 ± 1.875 ms/op SqlBenchmark.querySql 12 5000000 mmap none force avgt 5 22.818 ± 0.770 ms/op SqlBenchmark.querySql 12 5000000 mmap fc4 false avgt 5 42.683 ± 1.582 ms/op SqlBenchmark.querySql 12 5000000 mmap fc4 force avgt 5 24.243 ± 0.701 ms/op SqlBenchmark.querySql 12 5000000 mmap fc16 false avgt 5 42.540 ± 1.578 ms/op SqlBenchmark.querySql 12 5000000 mmap fc16 force avgt 5 22.294 ± 0.839 ms/op SqlBenchmark.querySql 19 5000000 mmap none false avgt 5 387.972 ± 6.159 ms/op SqlBenchmark.querySql 19 5000000 mmap none force avgt 5 326.290 ± 5.794 ms/op SqlBenchmark.querySql 19 5000000 mmap fc4 false avgt 5 442.899 ± 13.055 ms/op SqlBenchmark.querySql 19 5000000 mmap fc4 force avgt 5 415.133 ± 8.886 ms/op SqlBenchmark.querySql 19 5000000 mmap fc16 false avgt 5 587.755 ± 12.122 ms/op SqlBenchmark.querySql 19 5000000 mmap fc16 force avgt 5 423.662 ± 8.260 ms/op SqlBenchmark.querySql 21 5000000 mmap none false avgt 5 460.898 ± 12.384 ms/op SqlBenchmark.querySql 21 5000000 mmap none force avgt 5 268.478 ± 7.720 ms/op SqlBenchmark.querySql 21 5000000 mmap fc4 false avgt 5 470.816 ± 34.091 ms/op SqlBenchmark.querySql 21 5000000 mmap fc4 force avgt 5 291.954 ± 9.599 ms/op SqlBenchmark.querySql 21 5000000 mmap fc16 false avgt 5 521.974 ± 17.473 ms/op SqlBenchmark.querySql 21 5000000 mmap fc16 force avgt 5 334.489 ± 6.831 ms/op SqlBenchmark.querySql 22 5000000 mmap none false avgt 5 15.422 ± 0.448 ms/op SqlBenchmark.querySql 22 5000000 mmap none force avgt 5 15.386 ± 0.479 ms/op SqlBenchmark.querySql 22 5000000 mmap fc4 false avgt 5 15.448 ± 0.530 ms/op SqlBenchmark.querySql 22 5000000 mmap fc4 force avgt 5 15.382 ± 0.577 ms/op SqlBenchmark.querySql 22 5000000 mmap fc16 false avgt 5 15.474 ± 0.520 ms/op SqlBenchmark.querySql 22 5000000 mmap fc16 force avgt 5 15.358 ± 0.475 ms/op SqlBenchmark.querySql 23 5000000 mmap none false avgt 5 10991.428 ± 25.407 ms/op SqlBenchmark.querySql 23 5000000 mmap fc4 false avgt 5 18005.045 ± 83.700 ms/op SqlBenchmark.querySql 23 5000000 mmap fc16 false avgt 5 27198.713 ± 214.202 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]
