php pdo 与对比mysql_MySQL和PDO测试对比

说明

time 发生时间

class 类别

case 测试用例名称

step 用例被执行次数

runtime 总的测试时间

memory(peak) 消耗的最大内存

连接

time:2010-07-01 10:53:40, class:pdo, case:connect, step:100000, runtime:21.52, memory(peak): 262144

time:2010-07-01 10:54:08, class:mysql, case:connect, step:100000, runtime:4.42, memory(peak): 262144

结论：从连接上看PDO的效率会低一些。

插入

time:2010-07-01 10:37:55, class:pdo, case:insert, step:100000, runtime:7.96, memory(peak): 262144

time:2010-07-01 10:38:03, class:mysql, case:insert, step:100000, runtime:7.93, memory(peak): 262144

结论：两者差不多

查询

time:2010-07-01 11:06:41, class:pdo, case:select, step:100000, runtime:10.48, memory(peak): 262144

time:2010-07-01 11:06:54, class:mysql, case:select, step:100000, runtime:10.07, memory(peak): 262144