[Squirrel-sql-users] Memory utilization and slow start up and shutdown

[info <in...@dr...>]

Hi all,

A long-time Squirrel user here. Up until now I never had any issues. 
Been using mostly versions up to 3.9 with all kinds of databases for 
years. Currently I am working on a project that connects to every 
imaginable database, and I have the following JDBC drivers loaded:

DB2 JDBC-SQLJ 10.5

iSeries JTOpen 7.10

JTDS 1.3.1

MySQL connector 5.1.40

PostgreSQL 9.4.12

SQLite whatever latest is today.

I am almost positive that until I loaded SQLite, the startup and 
shutdown times were reasonable, within a few seconds. Since I loaded it, 
everything changed. It now takes up to 20 seconds to start the app and 
up to 30-40 seconds for it to shut down. It starts up with 800 MB of RAM 
allocated and grows to about 1.1 GB over the course of me running a 
handful of queries that return a handful of records from a couple of 
those back ends, no more than 1-2 back ends at a time. I never run 
anything that returns huge datasets.

I tried to unload SQLite but it did not change anything.

Since the machine that I am developing on is constrained on RAM (8 GB) 
and I have to run local Oracle tuned to use only 1 GB, DB2, MS SQL also 
tuned to use up to 1 GB, and Postgress, the memory utilization of 
Squirrel has become a considerable annoyance. I do not recall it ever 
using more than 256 MB of RAM without specifying Java command line 
option in the past. I am certainly not passing the memory option to Java 
to increase memory allocation. So it is a mystery what is going on.

I unloaded almost all plugins but there was very small difference in 
memory utilization. The UI has changed to vanilla AWT so it seems, and 
it is kind of nimbler to respond, but the overall problem remains.

Any ideas?

Thanks for your help!