Hi,

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.