Workflow taking much longer to run on Server than Designer

jsandona

Hello, we have a workflow that is running within about 2 minutes in Designer on the Virtual Machine where our Server is installed.

However, when we upload the workflow to the Server and run there (using the same inputs) - the workflow is now taking one hour to run. How could this be? What are some things we can do to try to reduce the runtime? 

It is a fairly complicated workflow unfortunately. These are the items that might be causing it to run slowly:

• Python code reaching out to a website to pull down a download (admittedly this has given us a lot of trouble. We are currently uploading the workflow using the service account, as directed by Alteryx Support)
• Reaching to a shared drive to re-save the download above

I have tried uploading/reuploading a few different times. All browse tools were removed, and I replaced the Data Cleanse tool. 

Is there anything else that may be worth trying?

Thank you!

afv2688

Hello @jsandona ,

are you able to check the logs from the server to see how the workflow runs? timestamps should tell you there which tools are taking longer to be processed. You could also create a document if you like with your workflow and see that way which tool is in the end giving you the problem, you might think that it has to do more with the python code but it might be the shared drive which is giving the issue.

It is a little effort but would help you detect the issue quickly.

Regards