I have 2 datatables and compare them by using for each row with each table.
I have used 2 times for each row to compare. I runned code directly on the local machine and it run fast, but when i publish project into Orchestrator and click to run from the Orchestrator and it run very slow.
Fine in that case open the project in studio and go to design tab → manage packages → Project dependencies-> upgrade all the package to latest version and then publish it to orchestrator one more time
Then try running from orchestrator
Make sure the network connectivity is good between machine and orchestrator
I have an difficult issue and dont know why and how to fix.
I have a project and run its source code on Local Machine , it run about 20-30s… but when i publish it into the Orchestrator and run, it run about 7-8mins.
I have tried to do some steps:
Clear all of old packages on Orchestrator and publish a new one.
Upgrade all of packages dependencies to the newest.
The network connection is good
Disconnect connection to the orchestrator and re-connect sometime.
I have checked and known it slow when ran from orchestrator at For Each Row activity. One For Each Row inside of another For Each Row. I have disabled ( comment out ) all activities inside of the For Each Row Loop and try to run but it still very slow from orchestrator… but on Local Machine always fast when run.
Any one has any suggest or solution for this case?