Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find DB Objects window too slow in latest SQL Developer version (bug?)

PaoloMJul 9 2012 — edited Jul 31 2012
Hello,
I come back on the issue that is affecting the most my productivity when using SQL Developer:
the Find DB Objects window is too slow to be usable when connecting to an Oracle schema with a lot of objects (like the APPS schema of a recent Oracle e-Business Suite instance, that contains about 170000+ objects).

I noticed that the Find DB Objects window performs way better in SQL Developer version 1.5.5 and I believe this is due to the fact that at a certain point the Find DB Objects window and the Extended Search window where unified to give the unusable window present in the latest version.

For example, when I am using the Find DB Objects window to look for a package with a certain name, in SQL Developer 3.1 the search takes about *25 seconds* to return the result, while in version 1.5.5 about *3 seconds*. Moreover, when I click on the results in version 3.1 there is a further delay and the whole application freezes for about *40 seconds* before opening a new window to show the package source, while in version 1.5.5 it takes about *1 or 2 seconds* to show the source after you click on the results.

Is it possible to do some performance optimization on the Find DB Objects window in the next release to make it perform like it used to in the oldest version?

Thanks,
Paolo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2012
Added on Jul 9 2012
7 comments
810 views