Flow Designer Performance Issue

[Shikha12]

Hi All,

I have created a flow designer , that is looping via Look Up Records. Issue is that when I am mentioning the Max result at 1000 it is running fine but if I increase Max result to 10000, it is taking alot of time.

How can I run my flow that it first process 1000 records and then wait for that completion and then process another 1000, so it doesnot impact the performance. I have seen some video we can try it with do Until loop in one flow and then call that subflow of look up, but I am not sure how subflow will notify that first 1000 records are processed and then it will process next 1000.

[Maik Skoddow]

Hi @Shikha12 

move the part which is iterating into a subflow and pass any parameters which can narrow down the result set to a list of result records less than 1000

In your flow you need then an iterator which is calling the subflow accordingly.

Maik

[Shikha12]

I have applied all possible filters that can narrow down the search, its coming maximum to approx  7000, not less that. I am new in flow designer not sure how iterator will work .

[Maik Skoddow]

Hi @Shikha12 

okay, I have no insight in your current use case and therefore cannot recommend anything else.

But at the end the Flow Designer is not a replacement for pure scripting when it comes to processing of mass data. Instead it is intended to design and run business processes. 

Maik