Hi Eric,
Oh, ok. I didn't realize that it slows down as it runs. I tried to reproduce that too with a "select * from dba_source", but it ran fast through the 30,000 row mark. Then I cancelled.
So, I have a few more questions:
- Is this script very long?
- Has Toad been running for very long before you start the script?
If either of these is a "yes", does it perform better if you restart Toad, then put that statement all by itself in a script and run it?
You might want to try the beta version, if you are able. We recently solved a memory leak related to script execution. I don't know if that is related to the slowness (I believe that the leak existed in version 15 as well), but it is worth a try.
You can get it here.
-John