search

brettwooldridge / HikariCP

光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Apache License 2.0
20.01k stars 2.93k forks source link

a new fast CP #1409

Closed JoyceLikeRose closed 5 years ago

JoyceLikeRose commented 5 years ago

I find a new CP,which show faster in its performance report, it is true? please help to validate it. URL is : https://github.com/Chris2018998/BeeCP/blob/master/doc/JDBCPool_Oracle11g_20190717.log

brettwooldridge commented 5 years ago

These are the HikariCP-benchmark results compared to BeeCP:

Benchmark                       (jdbcUrl)  (maxPoolSize)  (pool)   Mode  Cnt      Score      Error   Units
ConnectionBench.cycleCnnection  jdbc:stub             32  hikari  thrpt   16  29245.485 ± 3158.943  ops/ms
ConnectionBench.cycleCnnection  jdbc:stub             32     bee  thrpt   16  24325.375 ± 1302.627  ops/ms
StatementBench.cycleStatement   jdbc:stub             32  hikari  thrpt   16  47525.816 ±  853.582  ops/ms
StatementBench.cycleStatement   jdbc:stub             32     bee  thrpt   16  28225.630 ± 1174.199  ops/ms

Same test run with maxPoolSize=8 (the testing computer has 4-cores):

Benchmark                       (jdbcUrl)  (maxPoolSize)  (pool)   Mode  Cnt      Score      Error   Units
ConnectionBench.cycleCnnection  jdbc:stub              8  hikari  thrpt   16  32879.243 ± 2364.510  ops/ms
ConnectionBench.cycleCnnection  jdbc:stub              8     bee  thrpt   16  25845.337 ±  969.996  ops/ms
StatementBench.cycleStatement   jdbc:stub              8  hikari  thrpt   16  58265.882 ± 8043.810  ops/ms
StatementBench.cycleStatement   jdbc:stub              8     bee  thrpt   16  32002.166 ±  642.011  ops/ms
JoyceLikeRose commented 5 years ago

Thank you for supply a fastest CP to all. Accidental discovery the new, I just only be curious，so open the issue.

Use 1000 concurrent threads to test performance, maybe the way is wrong.