Skip to content

各种连接池性能对比测试

zhanming edited this page Mar 4, 2013 · 26 revisions

测试各种数据库连接池的性能

testcase

  Connection conn = dataSource.getConnection();
  conn.close();

测试执行申请归还连接1,000,000(一百万)次总耗时性能对比。

Java6 Environment

OS OS X 10.8.2
CPU intel i7 2GHz 4 core
JVM java version "1.6.0_37"

Java6 Benchmark Result

Jdbc Connection Pool 1 thread 2 threads 5 threads 10 threads 20 threads 50 threads
Druid 1,102 1,509 1,889 1,904 2,027 1,977
tomcat-jdbc 1,399 1,378 2,257 2,289 2,305 2,503
DBCP 3,144 3,834 6,276 6,408 6,563 6,783
BoneCP 4,327 3,598 3,800 5,242 9,402 19,066
jboss-datasource 4,912 3,049 6,868 6,512 40,146 43,748
C3P0 18,570 19,467 15,270 19,294 28,195 66,677
Proxool 16,221 14,455 24,688 38,905 48,087(Exception) 58,238(Exception)

Java7 Environment

OS OS X 10.8.2
CPU intel i7 2GHz 4 core
JVM java version "1.7.0_05"

Java7 Benchmark Result

Jdbc Connection Pool 1 thread 2 threads 5 threads 10 threads 20 threads 50 threads
Druid 898 1,191 1,324 1,362 1,325 1,459
tomcat-jdbc 1,269 1,378 2,029 2,103 1,879 2,025
DBCP 2,324 5,055 5,446 5,471 5,524 5,415
BoneCP 3,738 3,150 3,194 5,681 11,018 23,125
jboss-datasource 4,377 2,988 3,680 3,980 32,708 37,742
C3P0 10,841 13,637 10,682 11,055 14,497 20,351
Proxool 16,337 16,187 18,310(Exception) 25,945 33,706(Exception) 39,501 (Exception)

结论

  1. Druid是性能最好的数据库连接池,tomcat-jdbc和druid性能接近。
  2. proxool在激烈并发时会抛异常,完全不靠谱。
  3. c3p0和proxool都相当慢,慢到影响sql执行效率的地步。
  4. bonecp性能并不优越,采用LinkedTransferQueue并没有能够获得性能提升。
  5. 除了bonecp,其他的在JDK 7上跑得比JDK 6上快
  6. jboss-datasource虽然稳定,但是性能很糟糕
Clone this wiki locally
You can’t perform that action at this time.