Alteryx workflow performance issues

[narula8]

Hello Experts.

I have a workflow to read few entries from SQL Server table, process the data using macro and write back to  SQL Server table.

All these steps are taking ages to run. Can you please advise few tips to improve the performance.

Regards

S

[DavidSkaife]

Hey @narula8 

If you haven't already try running the workflow with Performance Profiling enabled. That will at least give you an idea of where the bottlenecks are and which areas can be enhanced.

Another good option is to consider using the In-Database suite of tools rather than the standard, and shift all (or as much as possible) of the work over to the database

[TimN]

Check "Show All Macro Messages" when running Performance Profiling as well.

[WeiLi]

can you shed light on how big is your database and how many columns you have?

i've noticed significant performance decrease if the number of columns is 1,000+.