请输入您要查询的百科知识:

 

词条 Query throughput
释义

  1. Background

  2. See also

  3. References

{{distinguish|Query rate}}{{More citations needed|date=December 2007}}

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

A number of query users (S) is chosen, each of which execute the full set of 17 queries in a different order{{Citation needed|date=February 2007}}. 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 (Ts) required between the first query starting and the last query or update function completing.

Therefore, the complete formulation is:

Note that if the test sponsor chooses S=1 for the throughput test, for ease of benchmarking it is permissible to omit the throughput test and compute the throughput metric using timings obtained during the power test. Similarly, it is permissible to schedule the insert/delete activity for the throughput test after all the queries complete.{{Citation needed|date=February 2007}}

See also

  • Transaction Processing Performance Council (TPC).[1]

References

1. ^{{cite web | title=TPC-Homepage V5 | website=TPC-Homepage V5 | date=2015-06-25 | url=http://www.tpc.org/ | access-date=2018-12-12}}
{{database-stub}}

2 : Computer performance|Temporal rates

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/11/11 1:45:41