Just as a side note – I always break every BMF project into two parts – data load in schema #1 and run workload in schema #2. Then I hand code the run workload
portion to do a CTAS (create table as select) to first populate/refresh the data in schema #2 from data in schema #1. This approach runs circles around trying to do anything from the client/console. I can refresh a terabyte sizes project in about 15 minutes
since al the work gets done internally by the database on the server. For large projects with many runs this is the only way to work …
Engr Tech Principal Engineer
Dell | Information Management
+1 469 888 5302
+1 949 754 8999
cell+1 469 693 3300
Quest Software is now part of Dell
From: Kevin Dalton [mailto:bounce-Kevin_Dalton@toadworld.com]
Sent: Friday, June 07, 2013 6:09 PM
Subject: RE: [Benchmark Factory for Databases - Standard Benchmarks Discussion Forum] New feature in 6.9 - ability to adjust loaded benchmark data?
The refresh functions perform delete, updates, etc. Everything that is necessary to get the data back to the initial state. The length of time it takes really depends on the initial scale
factor than the length of time the mixed test runs since it will go perform updates. deletes looking for key values so it will scan the entire table/index.
An example would be quanity columns which are updated from the mixed tests. If the data from these columns are not used in any decision making of the transactions themselves then there
is no performance impact not updating them back to the original values. This will save time for the refresh.
You can import these refresh transactions into BMF tests using the Transaction wizard, so you can call them separately.