Query throughput

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 to hours from seconds (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:

{\mathit {QthD}}={\frac {S\times 17\times 3600}{T_{s}}}\times {\mathit {SF}}

gollark: Also, they use Raspberry Pis for some programming education, but connecting to the package repositories they need for updates is blocked by the filtering proxy.

gollark: Sometimes they fail to PXE-boot or something like that and are just stuck displaying a black screen with some error messages on it.

gollark: In my school there are a bunch of displays with "information" on them (mostly news headlines and promotional images of the school) which apparently run Windows, because they frequently seem to undergo updates and sometimes are stuck on a blank desktop (do they not know how to make stuff autostart?).

gollark: Also since integers are nicer than decimal values.

gollark: Because bigger numbers → more better.

References

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.