Hi,
When I was working with squirrel on iseries I had the same slow startup
problem.
I had attributed it to the large number of libraries and very large number
of files (tables) in each Library that squirrel has to scan on Startup.
IIRC I mitigated the problem by loading only a small number of libraries
(schemas) and not caching them in Squirrel.
HTH
Erwan
Le mar. 10 nov. 2020 à 19:47, info <in...@dr...> a écrit :
> Once I deleted all aliases, the start time returned to normal 1-2
> seconds and shutdown time to instant.
> Now I am almost positive that it was a remote iSeries alias that slowed
> everything down.
> But there I hit a roadblock. I am not able to import my aliases back. I
> load the ZIP file, it shows all of my aliases in the import window, but
> dragging them back to the now emply alias list does not work. They drag
> but do not drop. What am I missing? I tried the Update button but it did
> not do anything either. Will I have to recreate all aliases from scratch?
>
> On 2020-11-09 05:06 PM, info wrote:
> > Exported the aliases and tried deleting MySQL aliases (I have 2x).
> > Beforehand I checked if any of my aliases had connect on startup. None
> > had.
> > Anyhow, this changed nothing at all.
> > Yes, I should be able to build Squirrel. I used to step through the
> > code of Ms Sql plugin a few years back in Netbeans.
> >
> > On 2020-11-09 04:18 PM, Gerd Wagner wrote:
> >> It's the best guess the logs brought me to.
> >> I could only be quite sure if I'd be able to reproduce your problem
> >> which I still can't.
> >>
> >> If you could build and debug SQuirreL on your system this would be a
> >> fair chance to find out what the problem is. For some information on
> >> this see
> >> http://www.squirrelsql.org/index.php?page=programing
> >>
> >> Gerd
> >>
> >> Am 08.11.20 um 23:27 schrieb info:
> >>> Does this explain the 30 second delay before the shutdown?
> >>> I do have 2x MySQL aliases, and when I click on them, each connects
> >>> almost instantaneously. They lead to a server on my LAN. However I
> >>> do not recall ever checking off the connect at startup option since
> >>> started using Squirrel many years ago. I will double check if any of
> >>> them have it.
> >
> >
> >
> >
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >
>
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
|