php原生API vs. PDO vs. Zend Db效率对比

来源：互联网发布：2016淘宝网购数据分析编辑：程序博客网时间：2024/05/16 10:21

目的及应关注指标

测试目的

本次测试对比php原生数据库连接、pdo连接方式及Zend Db在相同环境下执行select和insert性能对比测试，为数据库连接组件选型提供参考

需要关注指标

各种方式执行相对于php原生mysql数据库连接API执行时间比

测试环境及样本集

测试环境

测试服务器**.**.***.***数据库服务器**.**.***.***数据库类型Mysql 5.0.32php版本PHP 5.2.0-8运行环境shell

Zend Db采用pdo方式连接

测试样本

对一下样本集执行10次，列出每次执行时间并标注最小时间和最大时间
SELECT

sql语句SELECT * FROM wp_posts WHERE id < 3000数据条数2947执行次数250数据表说明id为主键

INSERT

sql语句INSERT INTO inserttest(a, b, c) VALUES (:a,:b,:c)执行次数250数据表说明a,b,c为非索引字段

测试结果集

SELECT

编号mysql原生pdoZend Db123.1815671921

18.7389979362

20.9781548977223.119073867817.9533500671

20.7274110317323.106215953818.337083816520.9653358459423.044408083

18.195773124721.0374000072523.095268964818.256955146820.7118120193

623.091155052218.502900838920.9910171032723.101035118118.001501083420.9725971222823.010216951418.386584997220.6824378967923.070796012917.993186950721.0708808899

1023.103039979918.436738967920.9718859196avg23.092277717618.2803072929420.91089327334

INSERT

编号mysql原生pdoZend Db10.207641839981

0.1752729415890.040556907653820.1906509399410.1826159954070.041603088378930.1656100749970.164512157440.0527379512787

40.1878268718720.1707949638370.040360927581850.153650045395

0.151349067688

0.040372848510760.157568931580.1747550964360.047731876373370.1743059158330.1654338836670.047997951507680.184123992920.230180025101

0.047538995742890.1766579151150.1560859680180.0431699752808100.1606090068820.1624050140380.0401198863983

avg0.17586455345160.17334051132210.04421904087067