Flow is running more hours causing performance issue

ARAVINDA11
Tera Contributor

@Ankur Bawiskar  @Community Alums  @Sohail Khilji  @Maik Skoddow  or anyone please answer this query

 

If my THIRD PARTY SAP Data has less the flow is not taking time 

and the same flow has 790 - 1000 records it is keep on running more than 7+ hours

and it is causing instance performance issue, and the Active Transaction of node is more than 8+hours causing performance issue instance went slow down again we have to restart the node to fix this 

 

is there any way how to handle this

 

ARAVINDA11_0-1720250122220.png

 

4 REPLIES 4

OlaN
Giga Sage
Giga Sage

Hi,

Your question isn't very clear. Could you please describe in more detail, to give us a way to answer your question.

 

One thing I can say, from the picture you've provided.

Your execution is long running because you have multiple nested loops (5 levels at least).
Which will scale very poorly if it's many records to handle in every iteration.

See example below.

loop on 10 records 5 loop levels; 10 * 10 * 10 * 10 * 10 = 100.000 records
loop on 100 records 5 loop levels; 100 * 100 * 100 * 100 * 100 = 10.000.000.000 records (10 billion records!!)

 

So maybe you need to reconsider the design completely here?

ARAVINDA11
Tera Contributor

& @Mark Roethof  

Loop has been used for Multiple array.object and to convert for field mapping values if I need to reconsider how can I pass the input value of array.object from API Action please help me how can I consider redesign of flow

This seems to be you are looping at 5 levels, even loops beyond 2 levels are not suggested at all,

 

Your use case is specifically not clear, but you may use some intermediate result values to store so that your flow get optimised,.

Mate, I agree with you

I need 2 for each to proceed with the input value the another 3 loop for each created just for convert array object to object hence I can do the field mapping for the same let me know how can I do the field mapping of array object from action that should send object hence I can map string value