|
|
||
![]() |
||
Figure 4. Analyze Test Timing Data. You can use Microsoft Access PivotCharts to analyze test-timing data. This comparative timing chart for basic CRUD operations shows how the choice of query types, data-access architecture, and two- or three-tier Web services affects overall performance. PSP indicates use of parameterized stored procedures, PT-SQL represents parameterized T-SQL batch statements, and SP stands for nonparameterized stored procedures. OAKLEAF-MS10 is a white-box 833-MHz PIII server with 512 MB RAM and a 40-GB Ultra-IDE drive. This data, shown on a logarithmic scale, is summarized from about 4 million individual data retrievals, updates, and inserts with write-caching disabled. |
||