| Data Access Type |
GetOrder |
InsertOrder |
UpdateOrder |
| Parameterized Stored Procedure (Operations/Second) |
| Direct connection |
912.88 |
84.51 |
43.29 |
| XML Web services |
68.25 |
37.26 |
26.54 |
| Performance ratio |
13.38 |
2.27 |
1.63 |
| Parameterized T-SQL Batch (Operations/Second) |
| Direct connection |
754.45 |
64.89 |
49.82 |
| XML Web services |
67.06 |
35.84 |
30.55 |
| Performance ratio |
11.25 |
1.81 |
1.63 |
| Average |
12.31 |
2.04 |
1.63 |
| Performance Ratio—Parameterized Stored Procedure/T-SQL |
| Direct connection |
1.21 |
1.30 |
0.87 |
| XML Web services |
1.02 |
1.04 |
0.87 |
| Average ratios |
1.11 |
1.17 |
0.87 |
Table 2 Compare Direct Connections to XML Web Services. Stored procedures deliver better overall performance than T-SQL batch queries for data retrieval and insert operations in all test configurations, but batch queries execute updates about 13 percent faster than stored procedures. Adding a Web service layer causes a dramatic performance hit, as expected.
|