I've been performance tuning some workflows, and noticed that some macros are the big performance problem. I tuned one batch macro and turned it into a standard macro, which reduced processing time from 13 minutes to 5, which was great. But then I noticed while working on the new standard macro in design mode, just running the dataset through the tools, that it runs in about a minute. And then I save and run it as a macro with the same data going in, and it takes almost 5 minutes.
I wasn't surprised the batch macro was much slower, it's iterating one batch at a time and I'm not surprised there's a performance hit, but the standard one makes no sense. It's the same tools running, but takes nearly 5 times as long. Is this normal? If so it makes macros fairly useless, which is unfortunate because I've been using them everywhere that needs this repeating code.
I could post the macro itself, but was really just wondering if this is a known flaw with Alteryx, and that we can always expect standard macros to run much slower than if they weren't macros. Is that the case?
thanks!
