Reporting Tool Running Time

[Gamaliel]

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.

[Gamaliel]

Even if I open it through analytic app, still the same results.

[Jonny · Accepted solution]

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

[Gamaliel]

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

[Jonny · Accepted solution]

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 · Accepted solution]

I've checked your workflow @Gamaliel but @Jonny said it all !

Reporting tools are pretty slow and not known for their performance so you have to expect some processing time when you use them.

[Gamaliel · Accepted solution]

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

[Jean-Balteryx]

Thank you @Gamaliel but you should accept @Jonny's answer as solution, I only confirmed what he said ! Credit goes to him !

[atcodedog05]

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.

[atcodedog05 · Accepted solution]

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 : )