# Double clicking on clob column values (in SB or Editor) where there are 10+ mb of data hangs toad **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [June 9, 2020, 9:47pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036 "2020-06-09T21:47:32Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [June 9, 2020, 9:47pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/1 "2020-06-09T21:47:32Z")
Toad 13.3.0.181 I have noticed that it is quite a hassle to view clob data by double clicking onto it, since when the size of that specific row is more than 10+mb, then toad basically hangs, sometimes I wait for 5-10 minutes and then it finally loads that data. But very often, it does not happen at all. Viewing Session Browser from another toad program, shows actually that the session is inactive and does not do any work - hence seems like hanged. I have tried viewing it from **Schema Browser** and also via **Editor** , by writing select query. On the contrast, when clicking onto "Export dataset" - and using this to extract Clob rows - this is works quite well, even 20-30+MB Clob data can be extracted within seconds. This has been problem to me for a quite long time, so definetly not a problem for the past few releases. Raul ---
**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:** [June 9, 2020, 10:11pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/2 "2020-06-09T22:11:03Z")
Hi Raul, I am about to stop for the day but I just set a reminder to check on this tomorrow. I appreciate your flurry of minor issues that you've brought up lately. Really, I'm not being sarcastic. I enjoy getting things fixed, but I can't fix them if I don't know about them. So thank you. Keep 'em coming. -John ---
**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:** [June 10, 2020, 1:16pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/3 "2020-06-10T13:16:36Z")
I just loaded 20Mb worth of data into the popup editor. It took about 5 seconds. Are you using XML data or anything else that is syntax-highlighted in the popup? ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [June 10, 2020, 1:33pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/4 "2020-06-10T13:33:32Z")
XML usually yes. How did you try, when all data was in single row or data was distributed on multiple rows? Raul ---
**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:** [June 10, 2020, 1:36pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/5 "2020-06-10T13:36:19Z")
multiple. I made a copy of c:\WIndows\servicing\Sessions.XML and am using that. It is 20Mb. XML takes a little longer but it still isn't bad for me. It helps to set syntax highlighting to plain text. Posting changes to the data takes the longest. I don't know if I'll be able to improve that but I'm looking. ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [June 10, 2020, 1:38pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/6 "2020-06-10T13:38:36Z")
> [@JohnDorlon](#): > > XML takes a little longer but it still isn't bad for me How much longer..? If you compare 20MB plain text file vs xml file, what would be the difference..? Try with single line also and with xml. Just thinking, can't there be an issue, so that toad wanting to access internet to validate this xml somehow..? (our toad is in company intranet, we have created registry entry to restrict internet though) ![image](https://global.discourse-cdn.com/quest/original/2X/b/bef3dd640e3085252b8645d1f7bfe400a67050d1.png) Raul ---
**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:** [June 10, 2020, 1:46pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/7 "2020-06-10T13:46:27Z")
Well, it's still coming up in about 5 seconds but scrolling around is sluggish until I turn syntax highlighting off. Posting takes about a minute either way. We aren't doing any validating. Can you email me a large single line XML file? I don't have one handy. -John ---
**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:** [June 10, 2020, 2:01pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/8 "2020-06-10T14:01:32Z")
Nevermind, I found a 12Mb, single line XML file. It is much slower. ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [June 10, 2020, 2:04pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/9 "2020-06-10T14:04:47Z")
How much slower this 12MB opened up..? I just tried with 711527 character xml text (oneliner) (so about 700kb), and it took more than minute to open. Where is the option to turn syntax higlighting off..? And can I just turn syntax higlight off for xml only..? (so that sql syntax hilighting is still ON..?) Raul ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [June 10, 2020, 2:16pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/10 "2020-06-10T14:16:49Z")
Looks like this oneliner is the issue yeah. I loaded this 700kb file into database before modifying the xml text so that it is not oneliner anymore, then it opened up within second. With the oneliner xml, I can not even click onto any buttons there (for example **save to file** etc..) or scroll horizontally or nothing - everything laggs. Raul ---
**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:** [June 10, 2020, 2:17pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/11 "2020-06-10T14:17:16Z")
The popup editor took several minutes to become responsive when 12Mb of data was all on the same line. I think that is the key here. If your XML is formatted, it should be a lot faster. Are you storing it in CLOB or XMLTYPE columns? If XMLTYPE, go to main Toad options -\> Data Grids -\> Data. On the right, there is an option "Cast XMLTYPE to CLOB using..." If you set it to XMLSerialize, the XML data will be formatted, which should help. Note: If you change this option while a query with XMLTYPE is active, you'll have to re-execute your query for the change to take effect. If you are storing as CLOB...there is no way to get it formatted here. To turn off Syntax Highlighting, right-click, choose this. But the setting doesn't stick. So it's not going to help you with load times. I need to investigate a little more how much that really helps. If it's significant, I could make that an option for the setting to stick. ![image](https://global.discourse-cdn.com/quest/original/2X/e/edb4b3a7421ab6754297bd2b672b4131cc1dc607.png) ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [June 10, 2020, 2:27pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/12 "2020-06-10T14:27:41Z")
> [@JohnDorlon](#): > > I think that is the key here Yeap, I can confirm oneliner xml is the culprit here. By the way, when I remove first start tag **"\<"** from this text, then this text starts with: > ?xml version="1.0" encoding="utf-8"?\>\ [@JohnDorlon](#): > > Are you storing it in CLOB or XMLTYPE columns? We are storing it into CLOB columns. > [@JohnDorlon](#): > > ..I need to investigate a little more how much that really helps. If it's significant, I could make that an option for the setting to stick. Yeap, thanks. Glad it is reproducible. I'll leave you to it. Raul ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [June 11, 2020, 5:48am UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/13 "2020-06-11T05:48:56Z")
I was just thinking. If there is a known issue with the onliner xml _(at from certain length)_, isn't it just possible that toad automatically turns off the syntax highlight by default only for that specific clob..? Raul ---
**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:** [June 11, 2020, 9:36pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/14 "2020-06-11T21:36:58Z")
Turns out that it's not actually the syntax highlighting, it's the bracket matching that's causing the problems. There is some room for optimization in that code, and it can be run in a thread too. Also, I'm not sure that "certain length" is going to be the same for everyone. ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [June 11, 2020, 9:48pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/15 "2020-06-11T21:48:00Z")
Ok, let's hope for the best possible optimization.. Raul ---
**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:** [June 11, 2020, 11:00pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/16 "2020-06-11T23:00:39Z")
We'll get it solved one way or another. ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [July 7, 2020, 8:25am UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/18 "2020-07-07T08:25:11Z")
How did it go with that..? I recently noticed, that when I have huge single row sql query open in Editor window, then this also hangs. (try to modify some word or letter from the long sql query, it takes a lot of time) So probably the same issue. Raul ---
**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:** [July 7, 2020, 12:23pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/19 "2020-07-07T12:23:46Z")
There are two tickets in our internal bug tracking system for this. One to not perform a particular type of parsing on XMLTYPE because it doesn't apply (this will cut a lot of the time). The other to perform the work that's left in a thread, so your PC won't hang while it happens. Neither are done in beta yet but they won't be forgotten. It does seem like the same issue. If you want to email me your long SQL, I can check. ---
**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:** [July 15, 2020, 9:15pm UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/20 "2020-07-15T21:15:33Z")
This was a good sample for identifying a few performance issues. Three tickets in all came as a result, but things should be improved in the next beta. With a very large, one line XML document like that there's still a slight delay editing the text due to highlighting, but it's fairly reasonable considering the size of the document and lack of formatting. You should be able to work with your data without much issue now. ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [July 17, 2020, 8:46am UTC](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036/21 "2020-07-17T08:46:44Z")
> ...but things should be improved in the next beta. Does it mean that the next GA release also consists of these fixes..? Raul [Next page](https://forums.toadworld.com/t/double-clicking-on-clob-column-values-in-sb-or-editor-where-there-are-10-mb-of-data-hangs-toad/50036.md?page=2)