Toad World® Forums

Very Slow Response on Editor Output

Environment - Windows 7 32 Bit
Oracle 11g Release 11.2.0.2.0
Toad 11.0.0.116

When I run a query (using the Execute as a Script) in the Editor screen that returns more than 100 rows Toad takes an very long time to return rows.

tblatatimecard has 25841 rows and 27 columns (about 50% null)

select * from tblatatimecard
where rownum < 11
214 msces to run - less than a second to display results

select * from tblatatimecard
where rownum < 101
447 msecs - 5 seconds to display results

select * from tblatatimecard
where rownum < 200
735 msecs - 1 min 23 seconds to display results

select * from tblatatimecard
where rownum < 500
Canceled after 3.5 minutes

When I run the exact same queries using the Execute/compile statement at caret, the grid displays almost instantaneously. Also, if I do the same with Oracle’s SQL Developer I get almost instantaneously results.

My question is: Is there any reason why the big discrepancy in performance between the two ways of executing a query? Are there any settings that will improve performance?

Thanks
Rick Anderson

If someone knows why it takes longer I would be interested as well.

thanks!

Had to upgrade my Oracle client to 11.2.0.1 - btw -toad only works with 32-bit version. This seemed to speed things up considerably.

http://toadsoft.com/EditionRNs/ToadForOracle/ToadForOracle_11.5_ReleaseNotes.htm#SystemRequirements

Message was edited by: jennifer.chase_109