Skip to content

Instantly share code, notes, and snippets.

@alekkol
Created November 18, 2019 10:52
Show Gist options
  • Save alekkol/e7c1d6c0a08da683ca982a5c9e25d44f to your computer and use it in GitHub Desktop.
Save alekkol/e7c1d6c0a08da683ca982a5c9e25d44f to your computer and use it in GitHub Desktop.
JDBC pools benchmark results
# Run complete. Total time: 01:04:06
REMEMBER: The numbers below are just data. To gain reusable insights, you need to follow up on
why the numbers are the way they are. Use profilers (see -prof, -lprof), design factorial
experiments, perform baseline and negative tests that provide experimental control, make sure
the benchmarking environment is safe on JVM/OS/HW level, ask for reviews from the domain experts.
Do not assume the numbers tell you what you want them to tell.
Benchmark (executeDurationMillis) (pool) (poolSize) Mode Cnt Score Error Units
DataSourceBenchmark.statement 0 hikari 3 thrpt 5 673436.918 ? 110013.003 ops/s
DataSourceBenchmark.statement 0 hikari 5 thrpt 5 659675.043 ? 139009.074 ops/s
DataSourceBenchmark.statement 0 hikari 10 thrpt 5 469435.800 ? 640131.336 ops/s
DataSourceBenchmark.statement 0 hikari 20 thrpt 5 33327230.541 ? 17042281.996 ops/s
DataSourceBenchmark.statement 0 hikari 30 thrpt 5 80059848.372 ? 7506727.186 ops/s
DataSourceBenchmark.statement 0 tomcat 3 thrpt 5 37017.914 ? 5767.314 ops/s
DataSourceBenchmark.statement 0 tomcat 5 thrpt 5 37017.503 ? 6830.204 ops/s
DataSourceBenchmark.statement 0 tomcat 10 thrpt 5 69388.945 ? 21882.351 ops/s
DataSourceBenchmark.statement 0 tomcat 20 thrpt 5 715314.533 ? 37507.938 ops/s
DataSourceBenchmark.statement 0 tomcat 30 thrpt 5 715906.086 ? 27439.101 ops/s
DataSourceBenchmark.statement 0 c3p0 3 thrpt 5 53881.021 ? 3256.909 ops/s
DataSourceBenchmark.statement 0 c3p0 5 thrpt 5 88898.808 ? 4686.866 ops/s
DataSourceBenchmark.statement 0 c3p0 10 thrpt 5 121169.109 ? 5203.233 ops/s
DataSourceBenchmark.statement 0 c3p0 20 thrpt 5 134162.111 ? 8509.257 ops/s
DataSourceBenchmark.statement 0 c3p0 30 thrpt 5 148891.428 ? 8558.059 ops/s
DataSourceBenchmark.statement 0 dbcp 3 thrpt 5 121503.344 ? 19514.218 ops/s
DataSourceBenchmark.statement 0 dbcp 5 thrpt 5 162686.188 ? 37268.495 ops/s
DataSourceBenchmark.statement 0 dbcp 10 thrpt 5 252050.466 ? 24939.577 ops/s
DataSourceBenchmark.statement 0 dbcp 20 thrpt 5 299181.681 ? 78204.642 ops/s
DataSourceBenchmark.statement 0 dbcp 30 thrpt 5 306445.442 ? 41010.294 ops/s
DataSourceBenchmark.statement 1 hikari 3 thrpt 5 3238.659 ? 3897.443 ops/s
DataSourceBenchmark.statement 1 hikari 5 thrpt 5 4594.759 ? 424.143 ops/s
DataSourceBenchmark.statement 1 hikari 10 thrpt 5 9019.899 ? 185.740 ops/s
DataSourceBenchmark.statement 1 hikari 20 thrpt 5 18371.005 ? 116.568 ops/s
DataSourceBenchmark.statement 1 hikari 30 thrpt 5 18375.928 ? 89.850 ops/s
DataSourceBenchmark.statement 1 tomcat 3 thrpt 5 2617.409 ? 31.253 ops/s
DataSourceBenchmark.statement 1 tomcat 5 thrpt 5 4381.918 ? 39.042 ops/s
DataSourceBenchmark.statement 1 tomcat 10 thrpt 5 8778.770 ? 159.739 ops/s
DataSourceBenchmark.statement 1 tomcat 20 thrpt 5 18204.543 ? 330.281 ops/s
DataSourceBenchmark.statement 1 tomcat 30 thrpt 5 18217.939 ? 193.302 ops/s
DataSourceBenchmark.statement 1 c3p0 3 thrpt 5 2481.958 ? 47.290 ops/s
DataSourceBenchmark.statement 1 c3p0 5 thrpt 5 4177.846 ? 33.772 ops/s
DataSourceBenchmark.statement 1 c3p0 10 thrpt 5 8428.608 ? 382.147 ops/s
DataSourceBenchmark.statement 1 c3p0 20 thrpt 5 16987.397 ? 715.327 ops/s
DataSourceBenchmark.statement 1 c3p0 30 thrpt 5 18086.881 ? 185.097 ops/s
DataSourceBenchmark.statement 1 dbcp 3 thrpt 5 2689.378 ? 129.549 ops/s
DataSourceBenchmark.statement 1 dbcp 5 thrpt 5 4478.091 ? 227.185 ops/s
DataSourceBenchmark.statement 1 dbcp 10 thrpt 5 8976.443 ? 207.040 ops/s
DataSourceBenchmark.statement 1 dbcp 20 thrpt 5 18129.233 ? 427.776 ops/s
DataSourceBenchmark.statement 1 dbcp 30 thrpt 5 18100.474 ? 496.590 ops/s
DataSourceBenchmark.statement 5 hikari 3 thrpt 5 866.377 ? 2723.231 ops/s
DataSourceBenchmark.statement 5 hikari 5 thrpt 5 985.411 ? 335.706 ops/s
DataSourceBenchmark.statement 5 hikari 10 thrpt 5 1926.988 ? 51.989 ops/s
DataSourceBenchmark.statement 5 hikari 20 thrpt 5 3925.478 ? 9.091 ops/s
DataSourceBenchmark.statement 5 hikari 30 thrpt 5 3923.688 ? 8.933 ops/s
DataSourceBenchmark.statement 5 tomcat 3 thrpt 5 580.878 ? 3.294 ops/s
DataSourceBenchmark.statement 5 tomcat 5 thrpt 5 969.180 ? 5.442 ops/s
DataSourceBenchmark.statement 5 tomcat 10 thrpt 5 1941.415 ? 2.634 ops/s
DataSourceBenchmark.statement 5 tomcat 20 thrpt 5 3918.115 ? 18.766 ops/s
DataSourceBenchmark.statement 5 tomcat 30 thrpt 5 3920.220 ? 15.273 ops/s
DataSourceBenchmark.statement 5 c3p0 3 thrpt 5 578.322 ? 44.202 ops/s
DataSourceBenchmark.statement 5 c3p0 5 thrpt 5 961.858 ? 17.119 ops/s
DataSourceBenchmark.statement 5 c3p0 10 thrpt 5 1914.508 ? 12.287 ops/s
DataSourceBenchmark.statement 5 c3p0 20 thrpt 5 3847.347 ? 21.183 ops/s
DataSourceBenchmark.statement 5 c3p0 30 thrpt 5 3910.359 ? 7.799 ops/s
DataSourceBenchmark.statement 5 dbcp 3 thrpt 5 591.792 ? 66.214 ops/s
DataSourceBenchmark.statement 5 dbcp 5 thrpt 5 963.367 ? 85.080 ops/s
DataSourceBenchmark.statement 5 dbcp 10 thrpt 5 1930.728 ? 89.793 ops/s
DataSourceBenchmark.statement 5 dbcp 20 thrpt 5 3884.366 ? 190.010 ops/s
DataSourceBenchmark.statement 5 dbcp 30 thrpt 5 3888.300 ? 167.009 ops/s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment