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?
Duplicating the same issue won’t get you an answer sooner. Best practice is to continue your troubleshooting in the same thread, that way forum members who are trying to help you can read responses from other members.
For debugging, you can place a writeline activity after the activities you have and write Now.ToString
This will let you know how much time for each activity it is taking, based upon that you can trim you process example …If you are dealing with a lot of records in Datatable and do manipulations, then you can use Filter Datatable, LinQ functions to cut down the time