public inbox for [email protected]  

help / color / mirror / Atom feed
From: Andrew Protasov <[email protected]>
To: Aditya Toshniwal <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: pgadmin4 data browsing
Date: Wed, 7 May 2025 20:01:30 +0000
Message-ID: <DS0PR84MB3418AEEE5176AFAAB3BFAF9EE388A@DS0PR84MB3418.NAMPRD84.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAM9w-_miShw5S1XSK6-CO6nvOxE-sAFwiU7TLntk92mbX=sODw@mail.gmail.com>
References: <DS0PR84MB3418EBE194C2CC431BED29D2E388A@DS0PR84MB3418.NAMPRD84.PROD.OUTLOOK.COM>
	<CAM9w-_miShw5S1XSK6-CO6nvOxE-sAFwiU7TLntk92mbX=sODw@mail.gmail.com>

Hi,

It is pgadmin4 9.3. Try to fetch 10000 records (increase it in preferences) and try to pg up or pg downd continuously.

i can do 100k records this way in google spreadsheet inside chrome easy.

Andrew
________________________________
From: Aditya Toshniwal <[email protected]>
Sent: Wednesday, May 7, 2025 6:06 AM
To: Andrew Protasov <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: pgadmin4 data browsing

Hi Andrew,

We're already using react-data-grid which uses virtualization and is quite fast. You might be using an older version where the data was fetched from the server dynamically on scroll.

On Wed, May 7, 2025 at 4:00 PM Andrew Protasov <[email protected]<mailto:[email protected]>> wrote:
Hi,

Browsing of query result set using page up/page down keys is very slow and the slowest that I have seen in any sql tool. You need to user proper js widget like slickgrid for it, which has decent performance. Pgadmin3 did not have this issue at all.

Andrew



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com<https://www.enterprisedb.com/;
"Don't Complain about Heat, Plant a TREE"


reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pgadmin4 data browsing
  In-Reply-To: <DS0PR84MB3418AEEE5176AFAAB3BFAF9EE388A@DS0PR84MB3418.NAMPRD84.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox