Toad now uses the Scintilla editing component. There were many reasons for making the change, most notably Scintilla is under active development with a large user base and it’s fast.
Notable Changes:
Performance is incredible and gains over the last component are particularly impressive as the length of text increases.
Painting is better with an up-to-date look and feel.
Internal details of the lexer (syntax highlighter) are encapsulated within the component and not customizable by the end Toad user. This is a big step forward for reduction of unnecessary complexity in the Options window.
All editor option screens have been flattened so that all options are accessible within the main Toad Options window without digging around in secondary dialogs. This allows all editor options to be located from the Options search and Toad Jump.
Editor key bindings are listed in the Toolbars/Menus|Shortcuts Options page along with all other customizable commands. This allows you to easily spot conflicts between main menu buttons and edit control commands. Commands that could not be configured previously like CTRL+N to insert a named SQL statement can now be configured as well.
Every instance of the editing component should observe the same color settings so there will be no more text washout.
Some options are removed, others are new. Most options have their settings carried over from previous releases; however, a few options don’t have a 1-1 mapping to the old so the old value is lost. Those are replace tabs with spaces, show control characters, print line numbers, and print in color. For the time being syntax decorations and key mapping are lost. I’ll revisit these once the dust settles down.
Editor themes are possible now, but not implemented. As time permits it will be visited later in the cycle.
Other minor differences not worth detailing.
Known Issues:
Certain memos are tied to a dataset and the interaction between those memos and the underlying dataset is non-functional. Editing the SQL in Report Manager and Schema Browser custom queries are two that come to mind. There are a few others. These will be fixed soon.
The ability to fold all regions of a common type is missing from the Editor right-click menu.
The ability to fold a text selection is missing; however, due to the odd behavior that occurs when a selection partially includes an existing folding region this feature will not be reinstated. A new feature has been added that does almost the same thing. Hide Lines. It’s on the Editor right-click menu and will hidden all lines in a selection. Gutter images are added to denote the start and end of the hidden range, clicking on either of them will expand the range.
Supported folding regions are a small subset of prior Toad releases. These will be reintroduced in a future beta.
Incorrect popup sizing of the Insert Named SQL and Code Templates popups when executed 2-N times.
Print preview is missing.
Export Dataset Actions:
Export Dataset Actions now support Parameter Files to change table/view/mview/query being exported, as well as target location (file if one object being exported, folder if multiple)
With this version, after connecting to the database, Toad locks up. I’m just getting the Toad is not responding message until I use the task manager to kill it.
32 or 64-bit? Can you zip your user files folder and send them to me offline? michael.staszewskiquest.com
Thanks,
Michael
On 12/11/2014 10:09 AM, jcummings wrote:
RE: Beta Released (12.7.0.26)
Reply by jcummings
With this version, after connecting to the database, Toad locks up. I'm just getting the Toad is not responding message until I use the task manager to kill it.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
For anyone else experiencing Toad locking up you can disable the 3 options to highlight object names on the Editor|Display options page as a workaround until it's resolved. This case was specifically connecting to a schema (APPS) that owns a lot of objects.
Reply by jcummings
With this version, after connecting to the database, Toad locks up. I'm just getting the Toad is not responding message until I use the task manager to kill it.
Would those options also affect slow the schema browser retrieval for many objects? I tried turning them off, but the SB name retrieval is noticeably slower (>3800 objects).
I can do some time trials between 12.7 and 12.6 if that would help…
It might be the list those table names are inserted into. I ran into a similar issue today and the cause was a sorted list. Insertion is slower. I'll check tomorrow to see if I inadvertently added sorting somewhere.
Would those options also affect slow the schema browser retrieval for many objects? I tried turning them off, but the SB name retrieval is noticeably slower (>3800 objects).
I can do some time trials between 12.7 and 12.6 if that would help...
It's better, but still needs improvement. We have a two large test databases here that we can reproduce slowness on still. I'm making an additional pass on it.
Even in today's beta there are still some problems. We have our big db up and it'll be much better in next beta. There's still some room for improvement, but it is much closer to 12.6 load times.
Reply by jcummings
With this version, after connecting to the database, Toad locks up. I'm just getting the Toad is not responding message until I use the task manager to kill it.
Much like my initial reply attempt to this email which has vanished between my client and the forum, yes. Are you looking to make it larger or smaller?
I removed it because the gutter automatically sizes to show everything that’s enabled. There are 4 columns in the gutter. The left most for line numbers, the
next for bookmarks, the next for breakpoints and other gutter markers, and the right-most for folding. If you disable folding then the right-most gutter column is removed freeing up space. Similarly not showing line numbers will hide that column. The line
number column automatically adjust its width to be wide enough to show the numbers, but there is a minimum size that’s wide enough to show line numbers up to 10,000 (I think) without needing to resize. I could remove that minimum width to have it always dynamically
adjust. Other than that there’s not much to do at the moment with making it narrower because the middle two columns show 16x16 pixel bitmaps so the column has to be 16 pixels wide. The images do not scale so there’s no option to change those widths. These
same problems existed in the past yet an option was surfaced anyway and displays like this were possible…
Removing the minimum width would help for the majority of my scripts. I had the gutter reduced to a little larger than what you have displayed in your reply. If I can see what the dynamic without the minimum would look like, that would be great. Thanks.
Reply by droeschley_109
Removing the minimum width would help for the majority of my scripts. I had the gutter reduced to a little larger than what you have displayed in your reply. If I can see what the dynamic without the minimum would look like, that would be great. Thanks.
