This discussion is archived
3 Replies Latest reply: May 8, 2012 3:27 PM by Gary Graham RSS

SQL Developer too slow. What could be done?

mcardia Newbie
Currently Being Moderated
Hi!

I was wondering if there is a way to make sql developer run faster.

I´m not in a slow machine (Core 2 Duo, 2G RAM etc.).

When I use SQLTools (www.sqltools.net), for example for a simple query:
select * from cliente
It executes the statement in 78ms and fetch the result in 47ms (50 first rows). It is fast. A good tool.

If I execute the same statement in sqldeveloper it takes 10s (to fetch the same 50 first rows).

I´m using SQL Developer 3.1.07, with (oci/thick) and instant client 11.20.20.
I tried not to use oci/thick, but that make sqldeveloper even slower.

I also disable all extensions, except for subversion. But no changes.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points