Re: pgAdmin4 speed

On Thu, May 25, 2017 at 1:26 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> On Thu, May 25, 2017 at 4:14 PM, Shira Bezalel <shira(at)sfei(dot)org> wrote:
> >
> > On Thu, May 25, 2017 at 1:06 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> >>
> >> It's starting to become clear that the speed issues we've had reported
> >> are specific to the desktop runtime under Windows - which explains why
> >> most of the developers don't see them as the majority of us use Macs.
> >>
> >> Thank you to those that have provided tips and info to help narrow
> >> this down. I'm at PGCon at the moment and don't have a Windows VM on
> >> the machine I have with me, so I plan to look into this next week when
> >> I'm back.
> >>
> >
> > Thanks Dave. Also, here's another data point: A colleague in my office
> who
> > has pgAdmin 4 v1.22.2 desktop on Windows 10 installed says it only takes
> 3
> > seconds to launch. So seems like a Windows performance issue might have
> been
> > introduced between 1.2 and 1.5.
>
> 1.22.2 was pgAdmin III, which is totally different from pgAdmin 4. Is
> that really what he's running, or do you mean pgAdmin 4 v1.2?
>
>
​Ack, sorry about that. Miscommunication. He was referring to pgAdmin III
1.22.2.

​With his pgAdmin 4 v1.4 installation, he reports launching took 57 seconds
the first time and about 27 seconds the second time.​

Shira

>
> >
> >>
> >> On Thu, May 25, 2017 at 3:44 PM, Richard Greenwood
> >> <richard(dot)greenwood(at)gmail(dot)com> wrote:
> >> > Agreed, setting it up under Apache is a pain. But you can use:
> >> > python /path/to/pgAdmin4.py &
> >> > to launch a standalone server on port 5050. I have that in my .profile
> >> > in
> >> > Linux, Windows users could have it in autoexec.bat or whatever the
> >> > current
> >> > equivalent of that is.
> >> > I'm not saying that's an ideal solution for everyone, but for me that
> >> > configuration is easy to maintain and provides a faster, more stable
> >> > pgAdmin4 than pgAdmin3.
> >> >
> >> > On Thu, May 25, 2017 at 6:09 AM, Mike Surcouf <mikes(at)surcouf(dot)co(dot)uk>
> >> > wrote:
> >> >>
> >> >> I just changed from Windows desktop to SERVER_MODE with apache and
> it
> >> >> is
> >> >> completely different app.
> >> >>
> >> >> So much faster. Looks like there is something seriously wrong with
> the
> >> >> Qt implementation.
> >> >>
> >> >> Plus I only have to install it once.
> >> >>
> >> >> It’s a pain to setup in server mode though.
> >> >>
> >> >>
> >> >>
> >> >> From: pgadmin-support-owner(at)postgresql(dot)org
> >> >> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Richard
> >> >> Greenwood
> >> >> Sent: 24 May 2017 14:15
> >> >> To: pgadmin-support(at)postgresql(dot)org
> >> >> Subject: [pgadmin-support] pgAdmin4 speed
> >> >>
> >> >>
> >> >>
> >> >> There were several recent comments on this list about pgAdmin4 being
> >> >> slow
> >> >> which surprised me as I've found it to be faster than pgAdmin3. But
> >> >> then I
> >> >> saw pgAdmin4 on a Windows machine in standalone mode and realized
> what
> >> >> people are complaining about.
> >> >>
> >> >>
> >> >>
> >> >> I'm running the python server script and then using pgAdmin4 in a web
> >> >> browser. I suggest that folks who are bothered by the speed (lack of)
> >> >> in
> >> >> standalone mode give the server + browser setup a try. The server is
> >> >> launched with a single command:
> >> >>
> >> >> python /path/to/pgAdmin4.py
> >> >>
> >> >> then navigate to:
> >> >>
> >> >> localhost:5050
> >> >>
> >> >>
> >> >>
> >> >> Rich
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >>
> >> >> Richard W. Greenwood, PLS
> >> >> www.greenwoodmap.com
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > Richard W. Greenwood, PLS
> >> > www.greenwoodmap.com
> >>
> >>
> >>
> >> --
> >> Dave Page
> >> Blog: http://pgsnake.blogspot.com
> >> Twitter: @pgsnake
> >>
> >> EnterpriseDB UK: http://www.enterprisedb.com
> >> The Enterprise PostgreSQL Company
> >>
> >>
> >> --
> >> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> >> To make changes to your subscription:
> >> http://www.postgresql.org/mailpref/pgadmin-support
> >
> >
> >
> >
> >
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

​