Latest PAD update 2.22 affecting previous process

[Alvin_Hili1]

Hi PAD community,

Is anyone else having issued with the latest 2.22 update? Since it featured updates concering DataTable manipulation, it has affected a long running scheduled process, well at least a part of it. It's been running more or less on the same code for about 2 years. It used to take 6hrs when we had the Process Robot license, and then run time increased to 8hrs when we migrated the code to PAD. To be fair, we took the migration opportunity to include some additions and extra validation so the increase was expected, so it has had an average 8hr runtime since February.

Now a part of this process consists of opening a .csv file with no more than 500 rows of data, reading the colA field from every row and changing a UNIX time value into a normal time format, and writing the result in a newly added colA. The files will always all have a maximum of 500 rows and no more. This part of the process used to take 17mins on average, about 1.5mins for 12 files. Ever since the latest PAD 2.22 update, this part of the process is taking more than 2 hours, increasing the total process runtime to more than 10hrs.

Is someone else experiencing this issue? We definitely didn't change anything to the code, and the only datatable actions that are being used is reading the .csv file's data into a datatable to go through each row sequentially, same as was done before.

Thanks in advance

[Kresimir_RPA]

I've been experiencing similar thing on the recent desktop flow that I'm building. 

It's nothing complex, basically getting some data from web service and writing it into Excel files. For example, if there are 5 excel files, first one is done within one minute, after that it takes 3minute per excel. We are talking about maybe 150 to 200 inputs per table, which is nothing.

I'm using some 'For each' loops and 'Write to excel worksheet' actions. And also I tried to arrange the flow to smaller subflow sections, because it is suggested it would bring up the speed.

I'm running that on virtual machines. Only on one machine I get some decent speed results.

I've updated from 2.16 to 2.22 PAD version last week.

Regards,

Kresimir