ETL Multithreading

  • Updated on Feb 14, 2023
  • Published on Jan 18, 2023
  • 1 minute(s) read
  • Sharyl Clapp
  • Gina Magana
 Prev Next

How does it benefit me?

You can load data into ACE twice as fast.

What is it?

Multithreading is the ability to execute multiple threads concurrently. In ACE, this allows a single file to be loaded in multiple threads at the same time, thereby speeding up the load process. Multithreading is available for the following ETL load methods.

  1. Clients
  2. Insurance Companies
  3. Account Flags
  4. Bankruptcy
  5. Notes (Account)
  6. Deceased
  7. Disputes
  8. Email Logs
  9. Conversion Transactions (Transactions Load Method with Conversion = true)
  10. Text Message Logs
  11. Phone Logs
  12. Letters
  13. Legal Cases
  14. Itemization Transactions

What do I have to do?

Set Maximum ETL Threads

From the Setup -> System page, set the maximum number of ETL threads to use.

Maximum ETL Threads
The optimal number to set for Maximum ETL Threads is 10 to 30. Actual results may vary depending on file specifications and concurrent activity in your ACE application and database.

Set Multithreading to True

Set Multithreading to true for an ETL profile with one of the ETL load methods listed above. Run a job to load the data using the ETL profile.

When not to use
Multithreading should not be used if data being loaded is dependent on previous data being loaded from the same file.