Query throughput

Not to be confused with Query rate.

In computer science, query throughput (QthD) is a measurement used to determine the performance of a database system. The throughput metric is a classical throughput measure characterizing the ability of the system to support a multi-user workload in a balanced way.

Background

In the background there is an update stream that runs a series of insert/delete operations (one pair for each query user). The choice of the number of users is at the discretion of the test sponsor.

The throughput metric is computed as the total amount of work (S×17), converted from seconds to hours (3600 seconds per hour), scaled by the database volume (SF) and divided by the total elapsed time (T_s) required between the first query starting and the last query or update function completing.

Therefore, the complete formulation is:

${Q}{t}{h}{D}=\frac{S\times 17\times 3600}{T_s}\times {S}{F}$

References

This article "Query throughput" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Query throughput. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.

📰 Article(s) of the same category(ies)

• SCSI Enclosure Services
• Tail latency
• Orders of magnitude (mass flow rate)
• BAPCo consortium
• Database of Recorded American Music
• Standard database management analysis
• Maatkit

---