topic RE: Process taking more time to execute in production environment in Product Forum

Process taking more time to execute in production environment

pracmathur — Tue, 13 Jul 2021 06:57:00 GMT

Hi All,

One of the reporting process is taking more time to execute in production than in UAT environment. The report is getting written in an excel file. I compared the logs of both prod and UAT. It seems bot is taking few seconds more in writing to the excel file in prod.
Any idea why this is happening and how can I fix it?

------------------------------
REGENT PARK
Consultant
Personal
Asia/Kolkata
------------------------------

RE: Process taking more time to execute in production environment

HarshitRawat — Tue, 13 Jul 2021 09:37:00 GMT

Is the file location same in both UAT and PROD ? I mean NAS or Local drive

------------------------------
Harshit Rawat
Senior RPA Consultant
------------------------------

RE: Process taking more time to execute in production environment

krishna.kodimurali9 — Tue, 13 Jul 2021 10:48:00 GMT

PROD server gets slower due to lack of Load balancer on the server than the DEV/UAT.
Maybe you can check with the maintenance team if they can check the performance on PROD and improve accordingly.

------------------------------
Murali Krishna
RPA Consultant
------------------------------

RE: Process taking more time to execute in production environment

pracmathur — Tue, 13 Jul 2021 11:58:00 GMT

Yes the file location is exactly same, on shared drive.

------------------------------
REGENT PARK
Consultant
Personal
Asia/Kolkata
------------------------------

RE: Process taking more time to execute in production environment

EmersonF — Tue, 13 Jul 2021 12:36:00 GMT

@pracmathur Are the DEV UAT and PD server settings the same? RAM Memory, Processors? Usually this type of scenario usually happens when there is a gap between the server settings, I went through it where the place I developed a macro had 8 Cores and ran in 10 minutes, when I went up to production it took 1 hour, and we found that the machine it had only 2 cores

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
America/Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------

RE: Process taking more time to execute in production environment

david.l.morris — Tue, 13 Jul 2021 14:47:00 GMT

Is the logging level the same between the two Runtime Resources? I imagine you would have noticed this already if it were the case, but maybe verify that the same stages are being logged in UAT and Prod by comparing the logs. It's not a huge performance decrease, but if the logging were set to Log all Stages or something like that for the Prod Runtime Resource, that could account for it running slower.

Others have made some good suggestions as well, so I won't list everything again, but one other thing to consider is whether the shared drive being written to is the same between the two environments, assuming it's not writing locally.

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------