Execution Comparison Report
Summary
| Property | Value |
| Project | Performance test #12 |
| Report created | 30-Mar-2011 21:34:05 |
| DTM DB Stress version | 1.13.01, build: Mar 24 2011 15:58:49, ANSI, x86 |
| Number of reports to be compared | 3 |
| Report #1 | D:\reports\test1.strrep [ SQL 2 ] |
| Report #2 | D:\test1-index.strrep [ SQL 2 without index] |
| Report #3 | D:\test1-trigger.strrep [ SQL 2, triggers disabled ] |
Comparison Results
| Task | Thread | Metric | Unit | Report #1 Value | Report #2 Value | Report #3 Value |
| Report timestamp | 26-Mar-2011 08:09:53 | 30-Mar-2011 20:29:52 | 28-Mar-2011 10:09:03 | |||
| Total job setup time | Second | 0.6830 | 0.5690 | 0.6830 | ||
| 1 | Name | Task #1 idx | Task #1 | Task #1 v2 | ||
| 1 | Threads | 2 | 2 | 2 | ||
| 1 | 1 | Thread Executed | Iterations | 50 | 10 | 50 |
| 1 | 1 | Average speed | Iterations per second | 19.9840 | 6.4977 | 19.9840 |
| 1 | 1 | Average duration | Seconds | 0.0500 | 0.1539 | 0.0500 |
| 1 | 1 | Max duration | Seconds | 0.0580 | 0.2220 | 0.0580 |
| 1 | 1 | Min duration | Seconds | 0.0260 | 0.0980 | 0.0260 |
| 1 | 1 | Connection time | Seconds | 0.0260 | 0.0260 | 0.0260 |
| 1 | 1 | Disconnection time | Seconds | 0.0520 | 0.0040 | 0.0520 |
| 1 | 1 | Total duration | Seconds | 2.5020 | 1.5390 | 2.5020 |
| 1 | 2 | Thread Executed | Iterations | 50 | 10 | 50 |
| 1 | 2 | Average speed | Iterations per second | 18.5117 | 6.3857 | 18.5117 |
| 1 | 2 | Average duration | Seconds | 0.0540 | 0.1566 | 0.0540 |
| 1 | 2 | Max duration | Seconds | 0.1300 | 0.2020 | 0.1300 |
| 1 | 2 | Min duration | Seconds | 0.0080 | 0.0860 | 0.0080 |
| 1 | 2 | Connection time | Seconds | 0.0180 | 0.0700 | 0.0180 |
| 1 | 2 | Disconnection time | Seconds | 0.0020 | 0.0040 | 0.0020 |
| 1 | 2 | Total duration | Seconds | 2.7010 | 1.5660 | 2.7010 |
| 2 | Name | |||||
| 2 | Threads | 2 | 2 |