App runs slower in server than designer

[kunvai1]

Hi,

I created an Alteryx app that accepts date and client name and then shows respective data. My question is why the app runs slower on Server than Designer. It is taking longer time in Server to show result file. Is there a way I can optimize the performance?

Any help would be appreciated!

[fmvizcaino]

Hi @kunvai1 ,

The app will run slower in your server if the configuration is worst. Other than that, you have also the system settings where you can select the number of workflows to run simultaneously and some other configurations in your engine and worker. See below.

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-System-Settings-Deep-D...

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-System-Settings-Deep-D...

Also, data cleansing tool takes a lot of time to execute and it is always better to use a formula tool and some functions to clean your data. 

If you want to check which tool is taking longer in your server, activate the performance profiling to see what is going on. The results appears in your results tab

Best,

Fernando Vizcaino