|
From: Gerd W. <ger...@t-...> - 2020-11-06 19:25:29
|
Sorry, I can't reproduce your problem using https://github.com/xerial/sqlite-jdbc/releases/tag/3.32.3.2 which is latest today. ;) Could you give some more details? Here are some things you may try: - Delete all SQLite Aliases. - Remove the SQLite driver from SQuirreL's driver definition. Either by deleting its "Extra Class Path" entry (recommended way to use a driver) or by removing it from SQuirreL's lib directory (NOT the recommended way to use a driver). Anyway after this the driver definition should appear unchecked (red crossed) in your drivers list. Gerd Am 06.11.20 um 12:53 schrieb info: > 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! > > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
