# Lag before results are displayed in the editor's data grid **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [November 20, 2018, 11:35am UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276 "2018-11-20T11:35:10Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [November 20, 2018, 11:35am UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/1 "2018-11-20T11:35:10Z")
Hi, When I run queries on my editor, there is a lag before the results are displayed on the data grid. I understand that there is time spent on executing the queries itself but that isn’t the case here. for example, 1. I type this “select sysdate from dual” 2. I execute it using “Ctrl+Enter” or “F9”. 3. I see a popup for a fraction of a second before it disappears. 4. I see the result in the data grid after ~2 seconds. Opening a new instance of Toad doesn’t fix this. If I restart my machine, this issue is temporarily fixed before it comes back. I thought I could be running out of memory but when I look at resource monitor, I see I have ample free memory and CPU. Is this something you can help me with? Thanks Support Bundle for Toad for Oracle 12.12.0.39 Bundle: Toad for Oracle Xpert (64-bit), Add-Ons: Edition: Toad for Oracle Developer Edition Operating System: Windows 7 (Build 7601)Service Pack 1 Physical Memory Load: 19.54 % Physical Memory (Total): 24457 MB Physical Memory (Free): 19679 MB Virtual Memory (Total): 8388607 MB Virtual Memory (Free): 8387837 MB Swap Space (Total): 48912 MB Swap Space (Free): 43893 MB Toad Page File Usage (Virtual Memory): 214 MB Toad Working Set Usage (RAM): 273 MB ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [November 28, 2018, 1:23pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/2 "2018-11-28T13:23:24Z")
Anyone has a solution for this? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [November 28, 2018, 1:38pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/3 "2018-11-28T13:38:41Z")
Is the result section pinned or does it slide up/down? There is a bit of a delay when it slides, I don't know why. If you keep it pinned, then there is no no delay. The "pin" is here, in the top right of the output section. ![image](https://global.discourse-cdn.com/quest/original/2X/a/a1d2c8e621b6ca83c765c01af197c4ef8e362320.png) ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [December 7, 2018, 12:30pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/4 "2018-12-07T12:30:19Z")
Hi, Thanks for replying. It is pinned. When I start Toad, this isn’t a problem. The issue starts when its been running for a few hours. I don’t know why. ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 8:28pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/5 "2019-03-22T20:28:48Z")
I have now tried uninstalling and installing Toad 12.12 and this issue is still there. After the re-install, Toad works fine for a few hours and then it takes ~5 seconds to display the result for any query. I even tried select sysdate from dual; on different databases. Same delay. As of now, Toad is unusable for me. I would appreciate any pointers to fix this. The only things I imported from my previous installation are my connection and auto-replace settings. Thanks! ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 22, 2019, 8:33pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/6 "2019-03-22T20:33:59Z")
I wonder if a background session is timing out. Does it happen if you go to Options -\> Oracle -\> Transactions and uncheck "execute queries in threads"? ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 22, 2019, 8:34pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/7 "2019-03-22T20:34:01Z")
What about for a non-SELECT? Do those also take long time to execute? Try with this... ```sql begin null; end; ``` If that block is also slow please report on your SQL Recall options on the Editor|Code Assist page in Options. ![image](https://global.discourse-cdn.com/quest/original/2X/f/f3b8e3a96158d1c183e9ce109026a875769775ea.png) ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 8:54pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/8 "2019-03-22T20:54:14Z")
> [@mstaszew](#): > > begin null; end; Hi, Thanks for replying. The queries and execution times are fast. It is the data grid. For the following scripts, I pressed F5 (run as script) in the editor. The "Processing Script" popup window took a time to disappear but the query was fast. Here is the output: SQL\> set timing on SQL\> select sysdate from dual ## SYSDATE 22-MAR-19 1 row selected. Elapsed: 00:00:00.02 SQL\> begin null; end; PL/SQL procedure successfully completed. Elapsed: 00:00:00.02 My SQL Recall settings are same as in your screenshot. ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 8:55pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/9 "2019-03-22T20:55:22Z")
Hi, Thanks for replying. I have that option unchecked. Do you want me to check it and see if that helps? Thanks!! ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 22, 2019, 8:56pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/10 "2019-03-22T20:56:36Z")
if it's already unchecked then I don't think checking it will solve this but it won't hurt to try. ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 8:59pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/11 "2019-03-22T20:59:47Z")
I tried. Unfortunately, that didn't help ☹ ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 9:04pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/12 "2019-03-22T21:04:19Z")
If it helps, I have the same lag in Toad Script Runner (Alt T + T). The processing script popup takes ~5 seconds for select sysdate from dual; This is not a problem in sqlplus (Alt T + L). The result is instant. I am open to trying any settings change. Thanks!! ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 22, 2019, 9:05pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/13 "2019-03-22T21:05:17Z")
when the lag starts, is there lag if you do something in Toad that will make it do a background query (such as open or refresh schema browser?) ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 9:10pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/14 "2019-03-22T21:10:31Z")
Hi, I don't see a lag anywhere else in Toad. It's just the result set display in the Data Grid. In Query Viewer, the Execution Time shows 10 msecs. I have a lot of "Auto Replace" entries. Do you think this might be causing a problem? Thanks! ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 22, 2019, 9:14pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/15 "2019-03-22T21:14:20Z")
And just to confirm that it's the grid and not something else, disable the "Show Script Grids" option on the Scripts page in Options and then run a select as script (F5). Do you get the text output quickly? ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 9:19pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/16 "2019-03-22T21:19:50Z")
I just restarted Toad and the problem has gone away for now (the last couple restarts did not fix it). It'll be a couple hours before I see it again. I have disabled the "Show Script Grids" option. I'll get back to you with the results. Thanks again both of you. ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 9:28pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/17 "2019-03-22T21:28:54Z")
Okay, so the problem is back. I don't know if it is the way I run my queries. I usually leave a line between my queries and press Ctrl+Enter to execute it. I am used to this for 12 years now. This displays the results in the "Data Grid" and takes 5+ seconds. If instead, I highlight my query and press F5, it is very fast. ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 22, 2019, 9:31pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/18 "2019-03-22T21:31:48Z")
F5 and Ctrl+Enter couldn't be more different under the hood. To test your Ctrl+Enter vs. not then use F9. Select your query and F9 and compare to Ctrl+Enter. Both of those follow the same internal execution path and would be an apples to apples comparison just taking the statement detection logic out of the loop. ---
**Author:** ![siby.thomas](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@siby.thomas](https://forums.toadworld.com/u/siby.thomas)\ **Post date:** [March 22, 2019, 9:34pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/19 "2019-03-22T21:34:45Z")
I just tried F9. F9 and Ctrl+Enter show the same behaviour. They both take a long time to show the result in the Data Grid. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 22, 2019, 9:34pm UTC](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276/20 "2019-03-22T21:34:48Z")
I have done CTRL+Enter for a long time too and never really had any problem with it if I remember to leave a space between my queries. [Next page](https://forums.toadworld.com/t/lag-before-results-are-displayed-in-the-editors-data-grid/44276.md?page=2)