| Direct Connection |
XML Web Services |
| Single-Tier |
Two-Tier |
Three-Tier |
| GetOrder |
GetOrderWS |
GetOrderWS |
| UpdateOrder |
UpdateOrderWS |
UpdateOrderWS |
| InsertOrder |
InsertOrderWS |
InsertOrderWS |
| GetDataSet |
GetDiffGramWS |
|
Table 1 Use a Performance-Comparison Test Matrix. The test harness invokes these single-tier, two-tier, and three-tier operations in top-to-bottom, left-to-right sequence. Multiple versions of the procedures (except GetDiffGramWS) compare execution times of transacted dynamic T-SQL queries, parameterized T-SQL batch statements, and stored procedures. The GetDataSet and GetDiffGramWS operations compare data-retrieval times only.
|