windows 7 64bit. 4GB Ram. Core I5.
I used many versions of sql developer and I always feel it's slow in everything. Is there a light weight version of it or is there something I can do to make it faster?
There is no 'light' version of SQL Dev.
And with what is posted, we don't even know what it is about SQL Dev that you consider "slow". SQL Dev does not process the sql that you give it, nor the sql that it generates. Regardless of the source, sql is always processed by the database. The client (SQL Dev, sqlplus, Toad, some app written in C, etc) just sends the sql to the database, and takes whatever is returned.
The problem is not with processing sql. It's the IDE itself. It takes time to open. It takes time to show a a table. Time when choose "constraints and sql tabs".
1 person found this helpful
Have you already disabled all unneeded features?
It can speed up the start a lot.
You can do this under
Tools > Features
Untick everything you don't use, depending on your environment, perhaps Data Miner, OLAP, Hadoop, Spatial, TimesTen etc.
If you don't do migrations, unselect the complete Database Migrations tree.
If you use an external tool for Git, disable Git as well.
I tried your suggestion and I think it got better. Are there other suggestions to improve it more?
for any developer or tech/biz user, I would find a 4GB machine limiting. Like, you could run SQL Developer on it, but probably not Chrome, Office, and gosh knows what else.
I would hope a standard machine today would start at 8 if not at least 16GB of RAM
Using a 32bit JDK helps quite a bit on memory consumption, but not at all with speed - at least that is how it felt to me last time i only had 4GB of RAM
On Windows you can use 32bit executables even on 64bit versions of the OS without installing any other compatibility layer (you do not have to re-download sqldeveloper, the version with the bundled 64bit JDK works with a 32bit JDK after you adjust your config file).
Otherwise as suggested in Jeff's article, disable everything you do not need.