In relation to the thread above, I am prompted to ask
if there are other ways that UiPath performance could speed up during datatable looping.
For illustration purpose,
- I am attaching two projects that both generate numbers from 1 to 99999.
LoopPerformanceIssue.zip (37.6 KB)
- ByMacro → Executes a macro to generate the numbers.
- ByUiPath → Simply performs Add DataRow to DT then saves to excel.
- ByMacro → 1.19 min
- ByUiPath → almost 1hr
- Tasks like renaming and moving files have the performance result.
(no WF attached. )
No. of files to rename/move from one folder to another: 38000
- In Uipath → 7.25hrs
- In Macro → 35min
I know there is nothing wrong with using Macro,
but there are clients who want to purely use UiPath for implementation.
(especially for environments without Microsoft Office)
What approach do you suggest?
Thanks in advance!
Sorry for the long post.