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!

SQLDevelopper is slow when executing a query and closing tabs

847212Jan 11 2012 — edited Jan 12 2012
Hello,

I am experiencing problems of slowness with SQLDevelopper in the two following cases (since the first version I used, 2.0, and now with 3.1EA3) :

1. When I run a simple query with F9 (like 'select * from table1'), it takes SQLDevelopper *2 to 3 seconds* to display the results in the tab below the query.
Whereas in the (less sophisticated) TORA software, the same task is instantaneous.

2. When I run 10 queries at the same time with F9, it will open 10 query results below the query ; when I use the *'Close All'* menu on one of the query result, it will then take *7 to 12 seconds* to close the 10 query results.

It seems that the more time I keep my SQLDevelopper executable open, the more slowness I experiment.

Is there some trick in the configuration of SQLDevelopper to accelerate these behaviours ?
Or is it due to the technology used in SQLDevelopper ? (ie Java)

Thanks for reading.

PS : I am running SQLDevelopper (from installation file with the JDK1.6.0_11) on Windows XP SP3 Pentium 4 3Ghz 2Gb of RAM

Edited by: Bastabor on 11 janv. 2012 08:08

Edited by: Bastabor on 11 janv. 2012 08:10
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2012
Added on Jan 11 2012
4 comments
435 views