Re: "pgadmin4" - slow?

While I still wish pgAdmin4 was faster to start up I installed pgAdmin4
v1.5 today and performed some tests. Here's what I found.

The test machine is a Windows 7 VirtualBox VM. The host has a 4GHz
processor and an SSD. The host network connection uses an AC 1200 WiFi
card. I believe I'm testing the desktop version of pgAdmin4 since I'm
opening it from the Windows start button.

Starting pgAdmin4: 32 seconds to show "Servers" in the browser tree and
show the opening page.

When I click the plus (+) sign next to servers it takes 5 seconds for my
two local servers to show up. These are on two separate KVM Linux VMs.

It takes between 2 and 6 seconds to open each item in the database
browser tree.

I opened a table of 16,000 rows by clicking on the View All Rows button.
It took 3 seconds to open even though pgAdmin4 said it took only 1
second. In pgAdmin3 on the host machine it took about 1.5 seconds.

I opened a view that has almost 200,000 rows. In pgAdmin3 it takes 7
seconds. pgAdmin4 says it took 5 seconds but it really took 8 seconds.
Overall, the time is comparable between the two versions.

This is very encouraging because when I first tried pgAdmin4 I found it
to be too annoying to use. I will now give it another try.

*/Patrick Headley/*
Linx Consulting, Inc.
pheadley(at)linxco-inc(dot)com
(303) 916-5522
www.linxco-inc.com
On 06/13/2017 05:26 PM, David Lloyd wrote:
>
> Is it just me or is “pgadmin4” just terribly slow?
>
> I’m running it on a capable HP Laptop (it runs Postgres itself very
> well) but “pgadmin4” seems impossibly slow.
>
> Connecting to my Postgres from the local machine doesn’t seem to be
> the bottleneck (I have a Laravel application that runs just as well
> with php’s pdo_pgsql as well as pdo_mysql).
>
> Any ideas?
>
> DSL
>