Reducing Time

Hi @deguy42,

It depends if you are running the robot in debug mode or on execution via assistant or orchestrator. The later two will be as fast as any other method of iterating through the datatable. In debug mode you will observe that the For Each Row is slow.

Read more here:
There is no need to try to avoid For Each loops on large amounts of data - Help / Studio - UiPath Community Forum

Other method is to filter the datatable using the standard Filter Datatable Activity. This too will take time in debug mode, but will execute similar to For Each Row during execution.

Sadly, there is very little to optimize iterating through a datatable either with Linq or with standard datatable activities. The only one option I can think of is batch processing, but the time you save will not be a large chuck.