|
  
|
||
|
|
||
Individual threads are created and fired off for each query/table object. This allows many tables to be accessed at once and simultaneous writing of the data to the MS SQL Server.
If the application is running in single cycle mode, many smaller tables will complete very quickly.
if the 'Start' synchronization is kicked off again with active threads running, the threads will be queued up to 10 per table and execute as the longer threads complete.
This means that shorter tables can be synchronized again without affecting the previous cycle still executing on longer/bigger tables.
This is very useful if you are in the midst of a synchronization and some data has changed in a completed table.
