AnsweredAssumed Answered

Multi-Threaded Sub-Processes with Data Passthrough

Question asked by alees293863 on Mar 22, 2018
Latest reply on Mar 22, 2018 by alees293863

Hi Folks,


Looking for a little help trying to speed up some database writes.

I currently have a JSON Profile (Jobs) which I send to Sub-Processes to write to the relevant MSSQL Tables.


Each of the Sub-Processes uses the same data and similar decisions to ensure I have INSERT or UPDATE Dynamic Queries.


Currently - because the Sub-Processes require "Data Passthrough" I have to wait for each write to finish which takes a considerable amount of time.


What I'm looking to achieve is to send the JSON Profile to each of the Sub-Processes in Parallel so the write operations can happen at the same time.



As you can see above - I've been playing with Flow Controls to see what I can do but I'm fresh out of ideas - there are ~10 of these sub-processes I want to run in parallel with only the first one being required before the others (So assuming I can multi-thread this I will run the "(sub) Write Jobs Service - Job" first then run all remaining in parallel.


Has anyone experienced this and been able to get it working?


Kind Regards,