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