oratestToos工具

测试查询数据库的性能

1.使用说明

---sqlconfig.xml 配置需要查询的SQL
---oratestor.cpp 功能实现
---test.sh 执行脚本

-n 表示查询的次数
-i 表示sql id

---makefile 编译管理

2.执行结果

start runing [id:1] excute sql costime(ms):3 ,min=3 ,max=3 ,average=3
excute sql costime(ms):2 ,min=2 ,max=3 ,average=2
excute sql costime(ms):2 ,min=2 ,max=3 ,average=2
excute sql costime(ms):2 ,min=2 ,max=3 ,average=2
excute sql costime(ms):1 ,min=1 ,max=3 ,average=2
excute sql costime(ms):1 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1
excute sql costime(ms):1 ,min=1 ,max=3 ,average=1
excute sql costime(ms):1 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1
excute sql costime(ms):1 ,min=1 ,max=3 ,average=1
excute sql costime(ms):1 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1
excute sql costime(ms):1 ,min=1 ,max=3 ,average=1
excute sql costime(ms):1 ,min=1 ,max=3 ,average=1
excute sql costime(ms):2 ,min=1 ,max=3 ,average=1