|
|
||
![]() |
||
Figure 5. Compare Data-Access Performance. Faster execution times imply reduced database server loads for a given number of transactions per second. This PivotChart compares execution times for four data-access methods on two development computers: OAKLEAF-MS10 (see Figure 4 for the specs) and OAKLEAF-MS7, which is a Compaq DL-360 with dual 833-MHz PIII processors, 1 GB RAM, and a pair of 18-GB SCSI drives in a hardware RAID-1 configuration with write-caching disabled. T-SQL represents a set of nonparameterized T-SQL batch statements to illustrate the performance hit caused by query recompilation for each operation. |
||