When you perform a manual execution in TX DWA, the the default setting is to execute all items in one thread, without managed execution, and without logging either row counts or execution times. In most cases, it's preferable to use managed execution, multiple threads, and to log both execution time and row counts. This can provide much faster execution and provides more data for later analysis.
The best settings will vary from system to system, and will generally require some experimentation to optimize.
You can configure these settings and others for your manual execution by creating a default execution package. You can identify this package because the package name will end in "- Default Package".
New versions of TX DWA create a default execution package automatically when you create a new project. Projects that were created in older versions of versions of TX DWA may not include a default package.
How to create a default execution package
- On the execution pane, right-click on Execution Packages and select Add Execution Package.
- Give the new package helpful name, like Default.
- It is very important that you keep Include Steps empty. Otherwise it will execute those steps every time you manually execute anything in that project.
- Set Managed Execution to either Execution Number or Execution Time.
- Change the amount of Max. Threads. A common starting point is 4 threads.
- Press OK.
How to designate a default package
- Find the package you just created, or would like to make default in the execution package overview.
- Right-click on the package and select Set as Default Execution Package.
- Save the project.
Now when you execute a table, database, or your entire project by hand, it will use the settings you have specified.