Alteryx workflow speed

[Ozzym]

Hi

I have a workflow that is not yet live that looks at some raw data at a certain location on an excel file. been working good when i have been testing but today for some reason it is taking like 20 minutes to run. What is my best way of investigating/working out why it is so slow now. Would it be the file where i am saving the data or something else, any help appreciated

it is saying "allocating requested memory would be more than available physical memory" which can't be good :(

thanks

[vlad_kutateladze]

@Ozzym In workflow configuration> Runtime select  Enable Performance Profiling. You will see what tool affects the speed of your workflow  

[Felipe_Ribeir0]

Hi @Ozzym 

Besides what vlad suggested, i  suggest you to replace the auto field tool for the normal select tool (with the correct config) and the data cleansing tool for the formula tool (with the correct config). These tools demand too much of the machine with large datasets.

[Ozzym]

thanks Guys this is super helpful, i will take a look

have a good weekend 

[hellyars]

How much RAM do you have? Depending on your system's hardware configuration, you could also try increasing the amount of RAM allocated to Alteryx (under user settings).

You could also try selecting Use AMP Engine.