What is Query Performance?
There are generally two measures of query performance: response time, the time to get an answer to an individual query, and throughput, the number of queries that can be run in any time period; for example, queries per second). These two are related, but are not the same. In a heavily loaded system, you normally want maximum throughput, whereas in a relatively lightly loaded system, you probably want minimum response time. Also, some applications require a query to deliver all its hits to the user, whereas others might only require the first 20 hits from an ordered set. It is important to distinguish between these two scenarios.
Related Questions
- What gains in typical query performance result from high-levels of compression? If the compression is three to five times, is the query speed-up proportionate?
- Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
- How can I improve the performance (like speed up query data retrieval)?
