Alteryx is very slow - (30 seconds) to click on any tool in the flow when connected to the SQL database, its as if its polling the database for every click.
Can this behaviour be changed?
Thanks, Ryan
Hi @jacques993
You can change this in a couple ways. What you are experiencing is the auto-configure option of Alteryx.
Each time you update a tool the rest of the workflow auto-configures in order to know what metadata (aka fields) are available.
I'd imagine there is a bit of latency on your connection to SQL, which is the lag you are seeing.
You can either right click and cache the input tool, thus not pinging the SQL server each time anymore.
Or you can disable the auto configure function within the user settings > edit user settings > advanced > disable auto-configure.
However this will require you to press F5 in order to do the refresh manually.
Brill, Thanks! Thats done it! On the back of this, I have multiple flows going to multiple tables - is there a way to just have 1 sql output tool instead of 10 or so?
