Is it fine if we use more than 1 flow control in a single process to improve the performance of the process?
This is very generalized question, performance will depend on the data and flow of your process.
You can always use more than one flow control if requirement demands that. Though in some scenario where you have large data to process flow control will make the process slow.
If you are planning to improve the performance, flow control will only help if you are using parallel processing in it.
I am using parallel processing in it and as well as the data is huge.
Then you should go ahead and let community know how it goes.
Hi Madhushree DK
Like Rohit said,it all depends on the process.Flow control is not a straight up answer for increasing performance.As far as your questions goes,you can use 2 flow controls to increase performance in few scenarios.You can use first one to divide them into threads and second flow control to run as batches or you can go with both flow control shapes dividing data into threads.It all depends on the process and the requirement.There is no single defined answer for this.But if you can send a screenshot of your process,I can do various combinations and let you know which suits your requirement the best.
Vundela Bharath Kumar
Integration Practice Lead
Hi Bharath Kumar Vundela,
This is similar to my process, here the main places where the time consumption is more is mapping, and insertion into 2 tables where both the tables have different connections.
I am able to reduce the time taken while inserting the tables using flowcontrol multi threading. But mapping I am not able to reduce and the mapping is complex mapping with more than 200 elements being mapped. it is just either boomi functions or simple scripts with if else stmts or date and time functions being used.
The source is database here and a single transaction may be spread across multiple records in database thus unable to use the run as batches on 'n' documents under flow control. and the table's primary key is spread across multiple columns thus unable to use link element under database operation. and whenever I give without link element and with batch count as 1 and try to introduce the flowcontrol, I am losing the data. What else could be done to improve the performance?
Retrieving data ...