Toad editor issues in version 12.6.0.53

Toad for Oracle & DevOps Toolkit
1

1. Tabs on split file reload multiple times if file time stamp changes

Load a file which has multiple code blocks in it (e.g. package spec and body, multiple types with their specs and bodies in) using the split file option - creating multiple tabs. Have “Prompt to reload on activation if timestamp has changed” option enabled. If and the file timestamp changes, the multiple tabs get caught in some repetitive loop and can be loaded over and over again, with a prompt to reload on each one.

**2. Toad insight is unusable on large packages. **

I have a package body which is 10,000 lines, which refers to lots of objects, if I say declare a parameter and then want to declare the type (TABLE.COLUMN%TYPE), when I type <TABLE_NAME>, type a dot, for column names, I have to wait anywhere between 20-30 seconds for Toad Insight to do anything and TOAD doesn’t respond during that period of time. It makes the editor totally unusable. Smaller packages seem OK.

2

#1 I’ll take a look at this in this release

#2 There are some known performance issues. One involving large schemas and this that you mention. It’s on my list.

Thanks,

Michael

From: PaulZip [mailto:bounce-Paul@toadworld.com]

Sent: Wednesday, October 29, 2014 6:44 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Toad editor issues in version 12.6.0.53

Toad editor issues in version 12.6.0.53

Thread created by PaulZip

1. Tabs on split file reload multiple times if file time stamp changes

Load a file which has multiple code blocks in it (e.g. package spec and body, multiple types with their specs and bodies in) using the split file option - creating multiple tabs. Have “Prompt
to reload on activation if timestamp has changed” option enabled. If and the file timestamp changes, the multiple tabs get caught in some repetitive loop and can be loaded over and over again, with a prompt to reload on each one.

**2. Toad insight is unusable on large packages. **

I have a package body which is 10,000 lines, which refers to lots of objects, if I say declare a parameter and then want to declare the type (TABLE.COLUMN%TYPE), when I type <TABLE_NAME>, type
a dot, for column names, I have to wait anywhere between 20-30 seconds for Toad Insight to do anything and TOAD doesn’t respond during that period of time. It makes the editor totally unusable. Smaller packages seem OK.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

3

#2 should be fixed for 12.7. The fix will be available in the next beta (12.7.0.52). Please have a look and let me know if things are better. There were two major performance problems. The first dealing with large schemas, the second with large packages (or any single object). Both are resolved. Performance should be on par with older versions in my testing.