Use the Benchmarks page of the Settings dialog to specify some general benchmark testing options.
To specify general Benchmarks settings
Select Benchmarks. Review the following for additional information:
|Refresh statistics after benchmark load||
Select to instruct Benchmark Factory to refresh statistics after loading benchmark data.
Default = selected
|Check scale factor before running benchmark test||
Instruct Benchmark Factory to check the Benchmark Scale factor of the existing tables against the new Benchmark Scale requirement before executing a test.
To skip the scale checking process, do not select this checkbox.
Default = selected
Select a default setting for the Object/Data Retention method. The default setting applies to new Create Objects steps. Review the following for additional information:
|Create/Load objects if objects don't exist (no backup sets created)||
If objects do not exist, Benchmark Factory creates the objects and loads data.
If you select this option, Benchmark Factory does not create backup tables.
|Delete benchmark objects after completion of job||Benchmark Factory deletes objects after a job is finished.|
|Refresh data using backup sets||
When backup sets exist, Benchmark Factory reloads data and recreates indexes.
If backup sets do not exist, Benchmark Factory creates objects and loads data. Then Benchmark Factory creates the backup tables.
|Recreate objects and reload data every execution||
Benchmark Factory always deletes the existing objects and then recreates/reloads for each job execution.
This allows you to ensure that the dataset is always in initialized status.
|Refresh data using inserts||
If data does not exist, Benchmark Factory uses bulk insert to load data.
If the following Benchmark Settings are selected,
and the Benchmark Scale factor of the existing tables does not match the new requirement, the process of inserting additional data or deleting data my run long, depending on the size of the existing data and number of indexes.
Note: If database does not support bulk insert, insert is used.