使用JMeter测试一下有无数据库连接池的性能：
1.下载JMeter
2.无连接池的servlet
Java代码
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the GET method");
out.println("test 1000 add");
DBManager db=new DBManager();
db.getConnection();
db.addUser("persia", "persia");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
} |
有连接池的servlet情况：
Java代码
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the GET method");
out.println("test 1000 add");
DBManagerByPool dbp=new DBManagerByPool();
try {
dbp.addUser("persia", "persia");
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
} |
3.JMeter测试配置：
（1）默认新建的测试计划里面新建线程组
线程数5，循环1000
（2）设置HTTP请求默认值
（3）添加（sampler里面）2个HTTP请求分别对应有无连接池
（4）添加监听器--聚合报告
（5）运行--启动
4.测试结果：
Java代码
- Label # Samples Average Median 90% Line Min Max Error % Throughput KB/sec
- 无连接池池 5000 88 44 89 17 1012 0 35.57680677 7.052823998
- 连接池 5000 50 45 68 10 236 0 35.59098836 7.194662686
- 总体 10000 69 45 78 10 1012 0 71.14247704 14.24239042
|
发现无连接池的平均反应时间为88毫秒，而有连接池的平均反应时间为50毫秒。
