|
Overall Results |
|
|
|
| |
|
Test Phase |
TPS |
BPS |
Rows |
Bytes | |
|
10 |
1 |
9.75 |
36714.62 |
|
21330928 |
|
Transaction Results - User Load: 10 | ||||
|
Name |
Executions |
Rows |
Bytes |
Avg Time |
|
delete from A WHERE ROWNUM<=1 |
58 |
0 |
0 |
0.011 |
|
update D set k = $BFRand(100) |
12 |
0 |
0 |
0.094 |
|
select * from D |
5 |
5 |
120 |
0.002 |
|
select * from C |
4 |
1406 |
792984 |
0.065 |
|
select * from B |
6 |
34396 |
18195484 |
0.987 |
|
select * from A |
48 |
4290 |
2342340 |
0.021 |
|
insert into C(h,i,j) values (7,8,9) |
473 |
0 |
0 |
0.024 |
|
insert into B(e,f,g) values (4,5,6) |
4918 |
0 |
0 |
0.021 |
|
insert into A (a,b,c) values (1,2,3) |
137 |
0 |
0 |
0.03 |
可见TPS约为并发用户数，应该还有上升空间，各SQL语句执行次数比较符合理想目标。用时方面就是B表查询需时较长（同时B表的行数也比较多），其他比较理想。另估计是B表的查询延迟了其他的操作，导致SQL脚本总体执行次数不算太多。
2、80~100个并发虚拟用户逐渐增加的5次迭代
|
Run Information | ||||||||
|
Test Run Id |
13 |
Status |
Completed | |||||
|
Start Time |
|
Stop Time |
| |||||
|
Comment |
1h | |||||||
|
Test Information |
| |||||||
|
Name: |
| |||||||
|
Test Type: |
| |||||||
|
Test Id: |
Version |
热门推荐精彩评论
关注51Testing
  
博文推荐热点聚焦 | ||||||
