pgadmin4 slow with large tables compared to pgadmin3

From: Colin Beckingham <colbec(at)kingston(dot)net>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: pgadmin4 slow with large tables compared to pgadmin3
Date: 2016-06-13 16:01:57
Message-ID: 575ED8F5.7040005@kingston.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

I have the latest fully patched pgadmin4. Runs fine on openSUSE Leap
42.1 using browser Firefox.
When I load a full large table such as the words table (140K records)
from wordnet, pgadmin3 takes about 2 seconds to display.
On pgadmin4 I wait about 30+ seconds and click through about 5 reminders
that "a script has stopped working, do you want to continue."
Eventually the table loads so this is not a bug report, more a question
about how to streamline access to large tables. I am quite aware that it
would run much faster by running a query with criteria asking for a
subset of the table records, but just wondering if this is to be
standard in pgadmin4. I can also disable the warnings, but this will
prevent me from seeing issues with other scripts.

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2016-06-13 16:17:03 Re: pgadmin4 slow with large tables compared to pgadmin3
Previous Message Dave Page 2016-06-13 15:35:23 Re: [pgAdmin4][Patch]: RM#1330 - Syntax error while running pgadmin_beta with python2.6.9