Hi,

 

The TPC-H benchmark (http://www.tpc.org/tpch/default.asp) is part of the MonetDB SQL source and the benchmark is run during weekends, as I can see on the TestWeb ( http://monetdb.cwi.nl/testing/projects/monetdb/Current/sql/.mTests03/times.html). How should I interpret the listed results? According to TPC, results should be stated as a "QphH@Size" value, where "QphH" is the number of queries per hour for the H benchmark, and "Size" is a "scaling factor". On the TestWeb, the results are stated as seconds of execution time.

 

Is it correct to compute the QphH value as follows:

Queries 01-22 took 1.985 seconds, so QphH is (3600 / 1.985) * 22 = 39.899 ?

 

What scaling factor is used in the benchmark runs; is this 1?

Is it possible to let the TestWeb run with scaling factor 100? Because that's the smallest Size for which results are published on the TPC web site.

 

Did anyone yet try to determine the Price of the test platforms, following the TPC Pricing Spec? TPC-H results normally include a Price/Performance metric in the form of $/QphH@Size, and I guess MonetDB could score particularly well on this metric.

 

 

Regards,

Wouter Scherphof.

 

Utrecht Professional School, The Netherlands.