登录 | 注册 | 论坛 | 搜索 | 会员中心 | 关于我们
论坛首页    »   数据库技术   »    评测下ADODB,ADODB_Lite,PDO和MDB2  
  
上一主题 下一主题
 标题:评测下ADODB,ADODB_Lite,PDO和MDB2  

yangyu
状态: code analyze frame
等级: 管理员发帖: 2009帖
排名: 第1名积分: 7202分
来自: 冰城
离线: 2008年11月13日
        
1 楼

评测下ADODB,ADODB_Lite,PDO和MDB2

测试环境:
硬件:赛扬2.66G,512M DDR

软件:Windows2003,Mysql-4.1.13,apache2.0.54,php5.1.0beta3(内置PDO,哈哈)
用ab做1000个连接,50个并发,不是很多,呵呵

ADODB:不是我说,最慢的果然是它


没有使用cache:
引用:
D:\server\Apache2\bin>ab -k -n 1000 -c 50 -k http://127.0.0.1/adotest.php
This is ApacheBench, Version 2.0.41-dev <$Revision: 1.121.2.12 $> apache-2.0
Copyright (c) 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright (c) 1998-2002 The Apache Software Foundation, http://www.apache.org/

Benchmarking 127.0.0.1 (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Finished 1000 requests


Server Software: Apache
Server Hostname: 127.0.0.1
Server Port: 80

Document Path: /adotest.php
Document Length: 0 bytes

Concurrency Level: 50
Time taken for tests: 72.593750 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Keep-Alive requests: 991
Total transferred: 220596 bytes
HTML transferred: 0 bytes
Requests per second: 13.78 [#/sec] (mean)
Time per request: 3629.688 [ms] (mean)
Time per request: 72.594 [ms] (mean, across all concurrent requests)
Transfer rate: 2.96 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 1.0 0 31
Processing: 62 449 3823.1 78 66125
Waiting: 62 448 3823.1 78 66125
Total: 62 449 3823.4 78 66125

Percentage of the requests served within a certain time (ms)
50% 78
66% 234
75% 281
80% 296
90% 328
95% 375
98% 421
99% 468
100% 66125 (longest request)

使用了cache:
引用:
D:\server\Apache2\bin>ab -k -n 1000 -c 50 -k http://127.0.0.1/adotest.php
This is ApacheBench, Version 2.0.41-dev <$Revision: 1.121.2.12 $> apache-2.0
Copyright (c) 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright (c) 1998-2002 The Apache Software Foundation, http://www.apache.org/

Benchmarking 127.0.0.1 (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Finished 1000 requests


Server Software: Apache
Server Hostname: 127.0.0.1
Server Port: 80

Document Path: /adotest.php
Document Length: 0 bytes

Concurrency Level: 50
Time taken for tests: 70.265625 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Keep-Alive requests: 991
Total transferred: 220596 bytes
HTML transferred: 0 bytes
Requests per second: 14.23 [#/sec] (mean)
Time per request: 3513.281 [ms] (mean)
Time per request: 70.266 [ms] (mean, across all concurrent requests)
Transfer rate: 3.06 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 1.0 0 31
Processing: 62 413 3760.9 78 63968
Waiting: 62 413 3760.9 78 63968
Total: 62 413 3761.3 78 63968

Percentage of the requests served within a certain time (ms)
50% 78
66% 78
75% 187
80% 203
90% 234
95% 250
98% 281
99% 343
100% 63968 (longest request)[/html]


MDB2,Pear的class,和ADODB功能相近
引用:
[html]D:\server\Apache2\bin>ab -k -n 1000 -c 50 -k http://127.0.0.1/mdb2test.php
This is ApacheBench, Version 2.0.41-dev <$Revision: 1.121.2.12 $> apache-2.0
Copyright (c) 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright (c) 1998-2002 The Apache Software Foundation, http://www.apache.org/

Benchmarking 127.0.0.1 (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Finished 1000 requests


Server Software: Apache
Server Hostname: 127.0.0.1
Server Port: 80

Document Path: /mdb2test.php
Document Length: 0 bytes

Concurrency Level: 50
Time taken for tests: 53.484375 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Keep-Alive requests: 991
Total transferred: 220596 bytes
HTML transferred: 0 bytes
Requests per second: 18.70 [#/sec] (mean)
Time per request: 2674.219 [ms] (mean)
Time per request: 53.484 [ms] (mean, across all concurrent requests)
Transfer rate: 4.02 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.5 0 15
Processing: 46 326 2796.3 62 48609
Waiting: 15 326 2796.3 62 48609
Total: 46 326 2796.5 62 48609

Percentage of the requests served within a certain time (ms)
50% 62
66% 171
75% 203
80% 218
90% 250
95% 265
98% 296
99% 343
100% 48609 (longest request)

  The Pursuit of Happiness
2008-04-22 16:24:35      
yangyu
状态: code analyze frame
等级: 管理员发帖: 2009帖
排名: 第1名积分: 7202分
来自: 冰城
离线: 2008年11月13日
        
2 楼


接下来是ADODB_lite,号称比ado小n多,测试结果也让人满意

引用:
D:\server\Apache2\bin>ab -k -n 1000 -c 50 -k http://127.0.0.1/adolitetest.php
This is ApacheBench, Version 2.0.41-dev <$Revision: 1.121.2.12 $> apache-2.0
Copyright (c) 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright (c) 1998-2002 The Apache Software Foundation, http://www.apache.org/

Benchmarking 127.0.0.1 (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Finished 1000 requests


Server Software: Apache
Server Hostname: 127.0.0.1
Server Port: 80

Document Path: /adolitetest.php
Document Length: 0 bytes

Concurrency Level: 50
Time taken for tests: 25.62500 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Keep-Alive requests: 991
Total transferred: 220596 bytes
HTML transferred: 0 bytes
Requests per second: 39.90 [#/sec] (mean)
Time per request: 1253.125 [ms] (mean)
Time per request: 25.063 [ms] (mean, across all concurrent requests)
Transfer rate: 8.58 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.5 0 15
Processing: 15 152 1310.7 31 22781
Waiting: 15 152 1310.7 31 22781
Total: 15 152 1310.8 31 22781

Percentage of the requests served within a certain time (ms)
50% 31
66% 78
75% 93
80% 93
90% 125
95% 125
98% 156
99% 156
100% 22781 (longest request)

  The Pursuit of Happiness
2008-04-22 16:25:01      
yangyu
状态: code analyze frame
等级: 管理员发帖: 2009帖
排名: 第1名积分: 7202分
来自: 冰城
离线: 2008年11月13日
        
3 楼


但是看了PDO就知道什么是速度了

引用:
D:\server\Apache2\bin>ab -k -n 1000 -c 50 -k http://127.0.0.1/pdotest.php
This is ApacheBench, Version 2.0.41-dev <$Revision: 1.121.2.12 $> apache-2.0
Copyright (c) 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright (c) 1998-2002 The Apache Software Foundation, http://www.apache.org/

Benchmarking 127.0.0.1 (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Finished 1000 requests


Server Software: Apache
Server Hostname: 127.0.0.1
Server Port: 80

Document Path: /pdotest.php
Document Length: 0 bytes

Concurrency Level: 50
Time taken for tests: 17.46875 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Keep-Alive requests: 991
Total transferred: 220596 bytes
HTML transferred: 0 bytes
Requests per second: 58.66 [#/sec] (mean)
Time per request: 852.344 [ms] (mean)
Time per request: 17.047 [ms] (mean, across all concurrent requests)
Transfer rate: 12.61 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.5 0 15
Processing: 15 103 886.9 15 15453
Waiting: 15 103 886.9 15 15453
Total: 15 103 887.1 15 15453

Percentage of the requests served within a certain time (ms)
50% 15
66% 46
75% 62
80% 62
90% 78
95% 93
98% 109
99% 125
100% 15453 (longest request)

  The Pursuit of Happiness
2008-04-22 16:25:10      
yangyu
状态: code analyze frame
等级: 管理员发帖: 2009帖
排名: 第1名积分: 7202分
来自: 冰城
离线: 2008年11月13日
        
4 楼


最后这个是标准的mysql函数库

引用:
D:\server\Apache2\bin>ab -k -n 1000 -c 50 -k http://127.0.0.1/mysqltest.php
This is ApacheBench, Version 2.0.41-dev <$Revision: 1.121.2.12 $> apache-2.0
Copyright (c) 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright (c) 1998-2002 The Apache Software Foundation, http://www.apache.org/

Benchmarking 127.0.0.1 (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Finished 1000 requests


Server Software: Apache
Server Hostname: 127.0.0.1
Server Port: 80

Document Path: /mysqltest.php
Document Length: 0 bytes

Concurrency Level: 50
Time taken for tests: 17.265625 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Keep-Alive requests: 991
Total transferred: 220596 bytes
HTML transferred: 0 bytes
Requests per second: 57.92 [#/sec] (mean)
Time per request: 863.281 [ms] (mean)
Time per request: 17.266 [ms] (mean, across all concurrent requests)
Transfer rate: 12.45 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.0 0 0
Processing: 15 105 904.5 15 15718
Waiting: 15 105 904.5 15 15718
Total: 15 105 904.5 15 15718

Percentage of the requests served within a certain time (ms)
50% 15
66% 46
75% 62
80% 62
90% 78
95% 93
98% 109
99% 125
100% 15718 (longest request)

  The Pursuit of Happiness
2008-04-22 16:25:19      
sina
状态: 你看我干什么?
等级: 会员发帖: 45帖
排名: 第1名积分: 83分
离线: 2008年09月05日
        
5 楼


PDO比MYSQL标准函数库都要快?

2008-06-23 12:39:47      
  
51/11


Powered by BbsFine 0.2 © 2002-2008 Xingmo.com Archiver
星模公司 ©2008 版权所有 京ICP备05011686号