# Very Slow Response on Editor Output

**URL:** <https://forums.toadworld.com/t/very-slow-response-on-editor-output/11030>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 13, 2012, 2:42pm UTC](https://forums.toadworld.com/t/very-slow-response-on-editor-output/11030 "2012-02-13T14:42:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rick.anderson\_046](https://avatars.discourse-cdn.com/v4/letter/r/8797f3/32.png) [@rick.anderson\_046](https://forums.toadworld.com/u/rick.anderson_046)\
**Post date:** [February 13, 2012, 2:42pm UTC](https://forums.toadworld.com/t/very-slow-response-on-editor-output/11030/1 "2012-02-13T14:42:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![emersokl\_562](https://avatars.discourse-cdn.com/v4/letter/e/8baadc/32.png) [@emersokl\_562](https://forums.toadworld.com/u/emersokl_562)\
**Post date:** [June 5, 2012, 7:54am UTC](https://forums.toadworld.com/t/very-slow-response-on-editor-output/11030/2 "2012-06-05T07:54:08Z")

</div>

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

thanks!

---

<div class="post-metadata">

**Author:** ![jennifer.chase\_109](https://avatars.discourse-cdn.com/v4/letter/j/71c47a/32.png) [@jennifer.chase\_109](https://forums.toadworld.com/u/jennifer.chase_109)\
**Post date:** [June 13, 2012, 1:51pm UTC](https://forums.toadworld.com/t/very-slow-response-on-editor-output/11030/3 "2012-06-13T13:51:10Z")

</div>

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](http://toadsoft.com/EditionRNs/ToadForOracle/ToadForOracle_11.5_ReleaseNotes.htm#SystemRequirements)

Message was edited by: jennifer.chase\_109