Toad World® Forums

Set disk read-write ratio for a TPC-H workload in BMF


#1

If it possible to set the disk read-write ratio for a TPC-H workload in Benchmark Factory?

We want to run a TPCH workload so that I can define the read-write ratio for each run. We’re looking for a way to capture the TPCH results based on the disk read-write ratio. For example, is there a way that we can specify for the TPC-H workload, “to generate disk read-write ratios of 80 percent read and 20 percent write”?


#2

The TPC-H workload is a read-only test. So you can not adjust the read-write ratio.

The Scalable Hardware test provides both read and write transactions so you can change the weight (mix) in a mix test so as to provide the read-write ratio that is desired.