Announcement Announcement Module
Collapse
No announcement yet.
Optimization: commit value and number of threads Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Optimization: commit value and number of threads

    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.
Working...
X