Código fonte do Post: Melhorando performance do pool de conexões com Hikari.
- PostgresSQL 9.6
- Maven 3
- Java 8
1 - Criar base de dados
psqlcreate database cp-benchmarkingcreate database cp-benchmarking-test
2 - Buildar projeto
cd hikari-connection-pool-benchmarkmvn clean compile
mvn -Dtest=DefaultSourceTest test
br.com.emmanuelneri.DefaultSourceTest : Started DefaultSourceTest in 13.579 seconds (JVM running for 14.295) o.s.jdbc.datasource.init.ScriptUtils : Executing SQL script from class path resource [reset-db.sql] o.s.jdbc.datasource.init.ScriptUtils : Executed SQL script from class path resource [reset-db.sql] in 25 ms. br.com.emmanuelneri.DefaultSourceTest : DataSource: org.apache.tomcat.jdbc.pool.DataSource@18fdb6cf{...} mvn -Dtest=HikariSourceTest test
br.com.emmanuelneri.HikariSourceTest : Started HikariSourceTest in 13.181 seconds (JVM running for 13.951) o.s.jdbc.datasource.init.ScriptUtils : Executing SQL script from class path resource [reset-db.sql] o.s.jdbc.datasource.init.ScriptUtils : Executed SQL script from class path resource [reset-db.sql] in 25 ms. br.com.emmanuelneri.HikariSourceTest : DataSource: HikariDataSource (HikariPool-1)