It’s been quite a while since firing up SQL Developer, but I just did so for comparison. It uses a completely different approach for the object picklist.
I haven’t played with options so I don’t know how customizable it is, but as a new user using the default option set here’s what I see. By default it only displays objects of the connected schema. I can see objects in another schema by starting to type out
the schema name. Similarly the picklist doesn’t show PL/SQL by default, but if I know the name of what I’m looking for and start typing it then the PL/SQL object will appear. I must know the starting character. I also can’t seem to get the picklist to invoke
after SELECT. I hit CTRL+Space, but nothing happens. It also doesn’t show a complete list of objects. I tried viewing public synonyms starting with “ALL” and it shows the last 50 or so synonyms when sorted alphabetically. I couldn’t get to all_objects without
starting to type it out. At some point I noticed the ellipsis in the list. If I double click that the list closes and reopens displaying all synonyms. It appears that objects are not cached as well. I can see queries executing every time I invoke the list.
This is not necessarily a bad thing though.
Toad, on the other hand, brings more of a sledgehammer approach and loads everything up front. It’s better suited if you need to browse the list of objects without knowing the name of what you’re looking for, but if you know the name and start typing it the
list is filtered quickly. Initial load time is longer, but the results are more complete. If the cache option is enabled then subsequent executions are immediate. It only takes milliseconds to populate and display the list. The list can be invoked anywhere
within your code as well.
My comparisons were done on my local XE database so performance was excellent in both tools. To throw a more real world test at it I connected to a large Oracle apps database we have that’s on the other side of the continent. Using the default option set in
Toad the load time was ~13 seconds. SQL Developer never gave me results. I waited well over a minute and tried to close. I received a message about a connection being busy and asked if I wanted to abort or try again. I clicked abort. After another minute I
was able to close SQL Developer and never did get any results. I closed and reopened SQL Developer and tried again. This time I didn’t have any problems when trying to close it, but after a minute or two I still never did get the picklist.
Of course I’m biased towards the Toad approach, but you could make an argument for each design.
If you want the fastest possible experience make sure stats are current on your database. Trim the results to only those object types of interest. If those in your class are primarily interested in writing SQL and are using tables and views mainly then enable
only those objects in Options|Editor|Code Assist. Add public synonyms if they want access to those as well, but this adds quite a bit of extra time. Toad 12.5 has a new option to exclude synonyms having a name starting with /. The default is checked. This
improves performance a lot. Also, enable the cache option if the objects in the schema they are working with are somewhat static. If objects are not being created/dropped regularly then caching would be wise. They can always refresh the cache by clicking the
refresh button within the popup.
On 02/01/2014 02:39 AM, damir.vadas_531 wrote:
Object autocomplete performance problem
Thread created by damir.vadas_531
Toad 184.108.40.206 x64 on Win 7 x64 SP1.
I really want to know how to speed auto competition of object names (tables and packages especially) in Toad editor.
This is one of the most common question in mine classes and have no straight answer on that. People shows SQL developer and immediately respond and this is really frustrating.
I know it has something with speed of PC but I’d like to get all possible hints in this area.
Please advice me what to do to make fast as it can be.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4259 / Virus Database: 3684/7045 - Release Date: 01/30/14