-
Title
TPC-C TPC-E range of data updated -
Description
Is the range of data touched by TPC-C and TPC-E determined by the #users? or will they randomly touch data throughout the entire database?
How BMF knows how many rows are in the database ?
-
Resolution
Yes the range of data accessed by the TPC-C is controlled by the number of virtual users to some extent.
For the TPC-C the virtual users are divided across the warehouses based off the maximum virtual users for the test and the scale factor. There is one warehouse per scale factor and 10 districts per warehouse. So for example if the scale factor was set at 20 and there was 40 virtual users;
VU #1 -> warehouse 1
VU#2 -> warehouse 2
.
VU#20 -> warehouse 20
VU#21 -> warehouse 1
.
So as long as the scale factor/number of warehouses do not exceed the maximum virtual user level, then the data will be spread across the entire database.
For the TPC-H the virtual users access data across the entire database.