Workflow takes longer to run on Alteryx Server than Alteryx Designer

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!

20241101 - Case Alteryx Server takes longer to run jobs than Alteryx Designer - Grupo Lamosa.pdf

Workflow

Accepted answers

All comments

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-Desktop-Workflows/td-p/1336164

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.!

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703