Multithread properties

A DBSync Worker Thread Pool is initiated when a task is started and automatically shuts down once the task is completed. This pool is dynamically created per task and terminates upon task completion.

multithreadpoolcount.schema=10

The tread count represents the number of schema change jobs that will run in Parallels default count set to 10, which means 10 schema change jobs will be running in parallel

multithreadpoolcount.object=4

4 objects will run in parallel for the read-and-write jobs for example, if four objects are selected all the four objects read and write will run in parallel to each other

There will be separate threads running inside each object, namely

multithreadpoolcount.read=4

inside each object, four read tasks will run in parallel to read records from the source.

multithreadpoolcount.Write=4

inside each object, four write tasks will run in parallel to write records from the source to the target.

multithreadpoolcount.queue.size=10

This property will queue tasks in batch sizes of ten

For example, if 50 tasks need to be processed, it will create a queue pool of 10, and the threads will pick it from the queue pool and process it. Once the thread has picked the task from the queue pool, it will add the next task in the pool.