Jul 25th, 2010, 10:44 AM
Optimization: commit value and number of threads
Are there known recommendations for the number of threads to use
for a simple batch program based on other parameters.
Basically my program reads data in a temporary table and writes them in other tables (in the same database).
Is it possible to have a formula for the number of threads to use (in order to obtain of course the best performance) based on to otpimize resources consumption :
- number of records in input data set
- commit step value
- number of CPU available on the platform
Is it possible to set dynamically the number of threads to use ?
Is there a risk of overhead if too many threads are used ?
Thanks a lot.