Performance
is usually measured in response time and
throughput. A good design and
indexing strategy leads to the largest performance gains.
Response Time
Response time is the time it takes for a single task to complete.
Several factors affect response time:
Reducing
contention and wait times, particularly disk I/O wait times
Using faster components
Reducing the amount of time the resources are needed
(increasing concurrency)
Throughput
Throughput refers to the volume of work completed in a fixed
time period. Throughput is commonly measured in transactions per
second (tps), but can be measured per minute, per hour, per day,
and so on.
Design Considerations
The largest performance gains can be realized by establishing
a good design and by choosing the correct indexing strategy.
Other considerations, such as hardware and network analysis,
can locate bottlenecks in your installation.