en>RookTorre: add link density of air

2014-03-18T16:35:10Z

add link density of air

← Older revision		Revision as of 18:35, 18 March 2014
Line 1:		Line 1:
	~~{{unsourced\|date=December 2007}}~~		The name of the author is Jayson. Mississippi is where her house is but her spouse wants them to transfer. Office supervising is exactly where her main earnings arrives from but she's currently utilized for an additional 1. To perform lacross is something he would never give up.<br><br>Also visit my weblog: psychics online ([http://jplusfn.gaplus.kr/xe/qna/78647 official source])
	~~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 language\|query]] users (S)~~ is ~~chosen, each of which execute the full set of 17 queries in a different order{{Fact\|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 (T<~~sub~~>s<~~/sub~~>~~) required between the first query starting and the last query or update function completing.~~

	~~Therefore the complete formulation is~~:

	: ~~<math>\mathit{QthD} = \frac{S \times 17 \times 3600}{T_s} \times \mathit{SF}<~~/~~math>~~

	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.{{Fact\|date=February 2007}}~~

	~~==See also==~~

	~~See [[Transaction Processing Performance Council]~~] ~~(TPC~~).


	~~{{database-stub}}~~

	~~[[Category:Computer performance]]~~

en>Ecb: linked to new Underground mine ventilation page

2008-10-28T22:09:45Z

linked to new Underground mine ventilation page

New page

{{unsourced|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 language|query]] users (S) is chosen, each of which execute the full set of 17 queries in a different order{{Fact|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 (T<sub>s</sub>) required between the first query starting and the last query or update function completing.

Therefore the complete formulation is:

: <math>\mathit{QthD} = \frac{S \times 17 \times 3600}{T_s} \times \mathit{SF}</math>

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.{{Fact|date=February 2007}}

==See also==

See [[Transaction Processing Performance Council]] (TPC).

{{database-stub}}

[[Category:Computer performance]]

Atkinson friction factor - Revision history

en>RookTorre: add link density of air

en>Ecb: linked to new Underground mine ventilation page