Workflow takes longer to run on Alteryx Server than Alteryx Designer

[Daniel Gordillo]

When scheduling a workflow in Alteryx Server it takes longer to run than if it is executed on Alteryx Designer in the same server.

For example; this workflow takes 16 seconds to run in Alteryx Designer (in Server); and if it runs as a job in Alteryx Server it takes 56 seconds (3x times more); the only thing the workflow is doing is an extraction from different databases.

Please see attachment.

Any suggestions would be appreciated!

[shancmiralles]

hi! I build on workflows and develop them as well to be uploaded on the server ( but we have a different team that modifies the WF before being approved to go to the server .. but maybe some of these stuff can help you..?)

https://community.alteryx.com/t5/General-Discussions/Understanding-Performance-Alteryx-Server-vs-Des...

hope this helps you a bit! 

[Daniel Gordillo]

Hello shancmiralles!

Thank you for your comment!

We don't have a QA team to review the workflow; but the one we're testing and having issues with it's fairly simple; just extract and move data from one database to another.

I took a look at the article; but couldn't find any suggestions on how to tweak the server configuration.

Best.!

[shancmiralles]

No worries @Daniel Gordillo !

We are all here to learn.. hopefully someone will comment on the article that can help you with your server concern! Cheers! 🎉 

[fmvizcaino]

Hi @Daniel Gordillo ,

I'm not sure if it's the same issue you're having, but I have something similar that still needs to be fixed.

In my case, the server is taking longer to trigger all workflows, increasing the total runtime shown in the Gallery. I have workflows that take 3 seconds to run on Designer and 30 seconds in the Gallery, but in reality, the workflow takes 27 seconds to start the execution and 3 seconds to run.

In my case, all workflows have the same behaviour. If it is only happening in one workflow, I have no idea what could be causing it because running on the Gallery or the Server`s designer is basically the same.

Best,

Fernando Vizcaino

[Daniel Gordillo]

Hi Fernando!

Thank you for your reply; it's a strange issue the one you're telling me; our situation is different, because the workflows are executed with no delay to start; and in comparison, with the runtime against Designer (in the same server) they take significantly longer to complete. Even if we launch the workflow manually in Alteryx Server and there is no other job running at the same time; a workflow that takes 1.5 minutes to run in Designer, it takes 4.5 minutes in Server.

Best,

Daniel Gordillo

[Manojpatnaik]

Hi @fmvizcaino , 

This can be because of the workflows getting queued in the gallery I believe and also may be the number of workflows in the gallery queue are more than the default number of workflows to be run.

Please check the CPU cores once which should optimally be 2 times the default number of workflows set to run in the server.

I hope this is useful and can be of some help.

[fmvizcaino]

Hi @Manojpatnaik ,

Thank you for your answer.

That is not the case; I don`t have enough schedules running on our server nor users running workflows manually. It looks like the firewall or another app is blocking/delaying internal API requests.

Best,

Fernando V.