SQL Editor Dialog dialog box takes a long time to open

[alexrossiter]

Hi - My team very frequently use SQL input from the student record system in Alteryx workflows (using the green input data tool). I've noticed in the last year, the SQL Editor Dialog is taking a long time (10-20 seconds) to open and seems to be getting worse. It might ot seem like much but it is incredibly frustrating from a productivity perspective as we are constantly back-and-forth in the workflows to refine the code and see the impact. I've attached a screenshot of the offending pop-up. Is this a common issue or is this something to do with our configuration?

[alexnajm]

In my experience it'll be related to your computer - can you free up space on your hard drive? Do you have enough memory?

It could also be database related since Alteryx has to connect into it - is the database bogged down?

[alexrossiter]

Thanks. I have just under 500 GB free on my hard drive and 32 gb ram (with nothing else running apart from Outlook and SQl Developer). When I run the same query via SQL developmer it is instantly responsive. Also, it's a common issue accross the team. 

[alexnajm]

Then use your "SQL developmer" for query building and use alteryx afterwards for pipeline automation :) those will generally be faster because its a more direct connection

[alexrossiter]

We do try to do that as much as possible - but we often  (a) finesse code in sql developer >> (b) paste back into Alteryx >> (c) check impact on Alteryx workflow >> (d) paste back into sql developer and finesse >> repeat... We might just have to learn to live with it being slow! 

[alexnajm]

Gotcha - then yes that may be the case. Here are some other possible suggestions to try: How To Troubleshoot Slow Database Read / Write Speed

[alexnajm]

Otherwise it may be worth a support ticket!