Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

General Macro Performance Improvement Tips

smchenry2014
5 - Atom

Hi all,

 

I've found a niche within my company of making Alteryx macros which connect to a wide variety of cloud data sources.  Most of these macros rely on building ODBC connection strings and utilizing ODBC drivers installed on the user's machine, while a few others make heavy use of the Python tool.  Recently, I've been give the directive to revisit these macros and make performance improvements in any way that I can.  I imagine most of these performance improvements will come from making change to the structure of my connection strings to utilize the full capabilities of the various drivers.  But before I went down that road, I wanted to know if there were any general tips and tricks I can use to improve the performance of my macros before I move to addressing driver-specific issues.

2 REPLIES 2
alexnajm
17 - Castor
17 - Castor

Are you using Performance Profiling to see which tools are taking the longest? You might also want to turn on "Show All Macro Messages" in the Runtime settings

 

Performance Profiling with AMP Engine

KGT
11 - Bolide

Agree with @alexnajm. This is the first step. This will hopefully let you know how much impact the connections have vs the process to know what else could be improved outside of driver specific. 

Labels
Top Solution Authors