Process Being Slow When Run in Flowchart

Hi @Dr_Raza_Abidi_PhD and @Srini84 ,

  1. Do review this thread from @postwick There is no need to try to avoid For Each loops on large amounts of data - Help / Studio - UiPath Community Forum to know why standard libraries are just as fast as linq queries. I assume these standard libraries also use linq queries in their source code.

  2. Another important reason why your automation may seem slow is because you ran it in debug mode. When this automation is run from the assistant or Orchestrator, you will notice it will execute much faster.

  3. 205K rows is a large number, so I suggest you run this process in 10K buckets and see if it improves execution time both in debug. Try different size buckets and choose the one which executes fastest. This result will replicate later when you run it from assistant or orchestrator.