Toad World® Forums

Performance Issue when running same query multiple times


#1

If a run a query multiple times, the subsequent runs are very slow. I am prompted that there is a currently running query when there is not (previous run completed successfully).

Background processes do not show anything else running other than the current SQL.

Thanks,
Michele Colson

4-4-2011 11-56-42 AM.jpeg


#2

Clarification: this issue occurs when running different queries as well, but more frequently if the same query is run multiple times.

In the print screen attached to the original post, I ran the first SQL successfully. Then ran the 2nd SQL. It has now been 10 minutes and Set 2 is not showing up in my results.