Hello,
I am asking for tips on how to shorten the running time for this workflow. After I attached reporting tools, I noted that it takes longer to run it (couple of minutes).
Thanks.
Solved! Go to Solution.
Even if I open it through analytic app, still the same results.
Hi @Gamaliel ,
one starting point for you could be 'Enable Performance Profiling'.
below excerpt from: Workflow Configuration | Alteryx Help
Have you tried that already?
if it is really the reporting tools that are taking the most time then it would be easier to help you by having a sample workflow as example so I can see the configuration you are using.
hope it helps!
cheers!
Jonny
@Jonny Please see the attached file. Now the running time is shorter since I changed the input files to sample files to protect client data privacy. The problem lies in using this workflow for larger input data. Hopefully, we can find a way to be efficient in this.
Thanks.
Hi @Gamaliel ,
I am not sure I have anything relevant to add here, the workflow looks very neat, well done!
I have profiled it and the render (55%) and input data (22%) tools seem to be taken most of the running time:
The reporting tools config & design is sound from what I can see.
The input from excel is not the best for performance if you have large amounts of data, usually csv, txt, yxdb, could run faster.
other than that, I could not tell. Maybe others will have something to add!
cheers!
Jonny
@Jean-Balteryx @Jonny same here. I noticed that the workflows are properly configured too. I finished running using the original file and it took me approximately 20 minutes.
Using also csv, txt, yxdb sounds good.
Thanks good. Patience is a virtue.
Performance profiling is definitely a really helpful option. Thanks for sharing this feature @Jonny 🙂👍
And its True that rendering does take time since its creating a formatted object.
Hi @Gamaliel
Here is my observation.
You are using below higlighted configuration which may not be needed. You can deselect them.
With enabled: 22.3%
Without enabled 16.97%
I got the same output after disabling it. And header and footer should be other fields than the actual table itself. You can look into this might increase the performance.
Hope this helps : )