Java数据库连接池 BoneCP
srcurl:http://blog.163.com/xing_mu_1/blog/static/661429020091029112556280/
BoneCP 是一个开源的快速的 JDBC 连接池。那么 BoneCP 到底有什么突出的地方呢,请看看下面的性能测试报告:
Single Thread
- 1,000,000 get connection / release connection requests
- No delay between getting/releasing connection.
- Pool size range: 20-50.
- Acquire increment: 5
- Helper threads: 1
- Partition count: 1
Multi-Thread
- 500 threads each attempting 100 get/release connection
- No delay between getting/releasing connection.
- Pool size range: 50-200.
- Acquire increment: 5
- Helper threads: 5
Multi-Thread 10ms delay
- 500 threads each attempting 100 get/release connection
- We introduce a 10ms delay (Thread.sleep()) between the acquire connection and the release connection to simulate work being done with the connection.
- Pool size range: 50-200.
- Acquire increment: 5
- Helper threads: 5
Multi-Thread 25ms delay
- 500 threads each attempting 100 get/release connection
- We introduce a 25ms delay (Thread.sleep()) between the acquire connection and the release connection to simulate work being done with the connection.
- Pool size range: 50-200.
- Acquire increment: 5
- Helper threads: 5
Multi-Thread 50ms delay
- 500 threads each attempting 100 get/release connection
- We introduce a 50ms delay (Thread.sleep()) between the acquire connection and the release connection to simulate work being done with the connection.
- Pool size range: 50-200.
- Acquire increment: 5
- Helper threads: 5
Multi-Thread 75ms delay
- 500 threads each attempting 100 get/release connection
- We introduce a 75ms delay (Thread.sleep()) between the acquire connection and the release connection to simulate work being done with the connection.
- Pool size range: 50-200.
- Acquire increment: 5
- Helper threads: 5
pic5
Prepared Statement (single threaded)
- Fetches a single connection then calls 1,000,000 connection.prepareStatement(...) followed by an immediate statement close.
- No delay between calls
- Max statements: 30
- Max statements per connection: 30
- Helper threads: 5
pic6
Prepared Statement (multi-threaded)
- 500 Threads each attempting 100 get/release connection with no delays. After obtaining a connection, make a call to connection.prepareStatement(...) followed by a close statement request.
- No delay between calls
- Pool size range: 50-200.
- Acquire increment: 5.
- Helper threads: 5
pic7
Prepared Statement (multi-threaded, 10ms delay)
- 500 Threads each attempting 100 get/release connection with no delays. After obtaining a connection, make a call to connection.prepareStatement(...) followed by a close statement request.
- 10ms delay between open connection/release connection to simulate work done by the application.
- Pool size range: 50-200.
- Acquire increment: 5.
- Helper threads: 5
pic8
Prepared Statement (multi-threaded, 25ms delay)
- 500 Threads each attempting 100 get/release connection with no delays. After obtaining a connection, make a call to connection.prepareStatement(...) followed by a close statement request.
- 25ms delay between open connection/release connection to simulate work done by the application.
- Pool size range: 50-200.
- Acquire increment: 5.
- Helper threads: 5
Prepared Statement (multi-threaded, 50ms delay)
- 500 Threads each attempting 100 get/release connection with no delays. After obtaining a connection, make a call to connection.prepareStatement(...) followed by a close statement request.
- 50ms delay between open connection/release connection to simulate work done by the application.
- Pool size range: 50-200.
- Acquire increment: 5.
- Helper threads: 5
Prepared Statement (multi-threaded, 75ms delay)
- 500 Threads each attempting 100 get/release connection with no delays. After obtaining a connection, make a call to connection.prepareStatement(...) followed by a close statement request.
- 75ms delay between open connection/release connection to simulate work done by the application.
- Pool size range: 50-200.
- Acquire increment: 5.
- Helper threads: 5
分享到:
相关推荐
java源码:Java数据库连接池 BoneCP.jar
一个比c3p0更快的数据库连接池,代码量少,简介,效率排行第一 比排行第二的连接池快25倍
开源数据库连接池bonecp附教程;据说是最快的数据库连接池
免责声明:资料部分来源于合法的互联网渠道收集和整理,部分自己学习积累成果,供大家学习参考与交流。收取的费用仅用于收集和整理资料耗费时间的酬劳。 本人尊重原创作者或出版方,资料版权归原作者或出版方所有,...
基于Java的数据库连接池 BoneCP.zip
基于java的开发源码-数据库连接池 BoneCP.zip 基于java的开发源码-数据库连接池 BoneCP.zip 基于java的开发源码-数据库连接池 BoneCP.zip 基于java的开发源码-数据库连接池 BoneCP.zip 基于java的开发源码-数据库...
基于java的数据库连接池 BoneCP.zip
Java数据库连接池 BoneCP的jar包
数据库连接池BoneCP源码分析报告
基于Java的实例源码-数据库连接池 BoneCP.zip
BoneCP 是一个高性能的开源java数据库连接池实现库。它的设计初衷就是为了提高数据库连接池的性能,根据某些测试数据发现,BoneCP是最快的连接池。
JAVA数据库连接池(C3P0,Druid,JNDI ,DBCP,Proxool,BoneCP) 源码包含各个数据库连接池的连接DEMO spring+mybatis+maven
Java中的BoneCP数据库连接池用法.doc
采用bonecp数据库连接池封装了Jdbc,当时也是网上下载了一份代码,发现不能用,只好自己修改代码,现在这个代码是可以直接运行的,测试用的Sql Server 2008,表很简单,就四个字段
数据库连接池,数据库连接池,数据库连接池,数据库连接池,
BoneCP 是一个高性能的开源java数据库连接池实现库。它的设计初衷就是为了提高数据库连接池的性能,根据某些测试数据发现,BoneCP是最快的连接池。BoneCP很小,只有四十几K(运行时需要slf4j和guava的支持,这二者加...
百度云盘分享 ... Java实现的FTP连接与数据浏览程序,实现实例化可操作的窗口。 部分源代码摘录: ftpClient = new FtpClient(); //实例化FtpClient对象 String serverAddr=jtfServer.getText();...
BoneCP 是一个高性能的开源java数据库连接池实现库。它的设计初衷就是为了提高数据库连接池的性能,根据某些测试数据发现,BoneCP是最快的连接池。BoneCP很小,只有四十几K(运行时需要slf4j和guava的支持,这二者加...
BoneCP 是一个高性能的开源java数据库连接池实现库。它的设计初衷就是为了提高数据库连接池的性能,根据某些测试数据发现,BoneCP是最快的连接池。BoneCP很小,只有四十几K(运行时需要slf4j和guava的支持,这二者加...