I assume this is an option setting that I have not set correctly… But I can’t find it…
I have a large SQL file (~35,000 lines) that basically has my “SQL History” in it so I can find stuff I have done before and copy it for new stuff… I always open this file on TOAD startup.
I have one machine with 18.104.22.168 installed and it works just fine (and has for many years).
I have a new machine with 22.214.171.124 installed and it behaves differently. Opening the file is fine. The first execution of any query in the file takes over a minute (I ran the SQL Tracker and the only SQL is the actual select I am running and the query itself only takes msecs to return). After that all queries in the file will run in the expected amount of time until you make ANY edits to the file. Then the delay occurs again. I can add a space on an empty line and it hangs.
It is as if it is parsing the entire file, but I can’t figure out how to stop it.
Anybody got any suggestions?