It would make sense if there was a need for Squirrel to perform some
very important actions on shutdown, but I cannot see any need for that.
What is it that Squirrel must access an iSeries alias for when a user
wishes to exit from the program that is so important that it is worth
waiting for 30 seconds for? Keeping in mind that I am not even connected
to iSeries most of the time! None of my aliases is configured to connect
on startup; therefore, there should be no attempts to connect on
startup. I am totally baffled by this issue that has no reason to occur.
On 2020-11-10 02:10 PM, Erwan Duroselle wrote:
> 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...
> <mailto: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...
> <mailto:Squ...@li...>
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >
>
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> <mailto:Squ...@li...>
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
|