Re: "pgadmin4" - slow?

Static resources will be good for caching :-) I would expect to see performance gains when using remotely via a browser. Thankyou.
I'm not sure whether QtWeb will benefit as much as its local traffic so round trips should be pretty instantaneous.
Unless QtWeb is horribly inefficient in which case I hope it helps.

-----Original Message-----
From: Dave Page [mailto:dpage(at)pgadmin(dot)org]
Sent: 14 June 2017 08:56
To: Mike Surcouf
Cc: Patrick Headley; pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] "pgadmin4" - slow?

On Wed, Jun 14, 2017 at 8:29 AM, Mike Surcouf <mikes(at)surcouf(dot)co(dot)uk> wrote:
> A 32 second startup time and a 2-6 seconds to expand each node is
> encouraging?

Unless you're on a slow connection, the node expansion time should be extremely quick the second and subsequent times in a session, and even then the delay should only occur for a small number of key nodes.
That's because it's loading the code for them on first expansion.

We're working on getting rid of that - whilst it works fine on non-Windows platforms (i.e. the initial delay is measured in fractions of a second, not seconds), clearly as we've found it's a problem on Windows. The work a number of people are currently doing involved making as much of the code static as possible (so it doesn't need to go through the templating engine), and then minimising and web packing it so it all loads at once. This will significantly reduce the number of round-trips between the browser and client, as well as the bandwidth required.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company