I use Oracle SQL Developer (version 22.214.171.1249) in Windows 10 64 bit.
It's connected to an Oracle database in the network through TNS.
Whenever I open "query builder" first time for a query, or after some changes in the SQL code it takes a lot of time (30-60 s) to load.
Also "completion insights" appear very slow (3-4 s), so I generally just finish typing table and column names before they appear (setting is 0.6 s for them to appear).
Based on above issues, I suspect SQL developer each time reads information from the database. Is there a way to make it store information locally instead? (structure of the database is quite permanent, it changes less then once a year)
I've had a look in task manager too, and what's strange is that even if SQL developer is unresponsive when it prepares the "query builder" it doesn't use many resources
Resources used by SQL developer during preparing the view:
- 0-1.5 % of my CPU (jumping up to 7 % for a few seconds)
- 600 – 650 MB of RAM (I've a total of 16 GB, from which 9 GB is free, so I don't think it would be a bottleneck).
- 0 MB/s disk and 0% network
In general performance is not affected this
- CPU use 10-30%
- memory: 7-8 GB used, 8-10 GB committed, 8-9 GB free
- disk usage: 0-5%