I am super interested in this problem (Execution performance of data processing tasks with UiPath Robots). I have a robot that converted Pdf’s → Excel, then extracted and formatted information from Excel Workbooks, and was shocked at the amount of time it took to process the data.
My Invoice Pdf’s files had tables with 6 or so rows of invoice headers, and between 1 and 20 rows of Invoice Line items. The widest the spreadsheets got was 10 columns (PDf → Excel added blank columns. I twas only 5 columns with data). My process took ~30 seconds per Excel File. I expected 1 second to read the file, 0.01 seconds to process the data table, and 1 second to write the results.
I have a dozen theories about the root causes, but have not dug into the details to prove / disprove any of them.
Can I ask a bunch of questions to help understand how you have structured the solution?
Q1: How wide is the spreadsheet?
It is 1,000 rows, but is it 5 columns, or 100 columns, or 1,000 columns?
Q2: How much complex processing do you do per row?
Is this executing per row 10 activities, 100 activities, 1000 activities?
Q3: Do you have other workflows that do the processing, and you invoke from inside the loop over the rows?
i.e. Do you use the invoke workflow activity inside your loop?
Q4: Have you done any instrumentation of your code to examine the performance issue?
Q5: Any chance you can share your Robot code and a sample slow spreadsheet?
I have already written one detailed blog posting about Cloud Orchestrator REST API Authentication, and I am thinking my second in-depth post will be about Robot Performance, so I intend to dig into this issue pretty deeply over the next 2 weeks.