Flow is running more hours causing performance issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2024 12:15 AM
@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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2024 01:14 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2024 08:42 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2024 12:10 PM
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,.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2024 01:37 AM
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