Обсуждение: Re: pgadmin4 data browsing

Поиск
Список
Период
Сортировка

Re: pgadmin4 data browsing

От
Aditya Toshniwal
Дата:
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 <a_protasov@hotmail.com> 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
"Don't Complain about Heat, Plant a TREE"

Re: pgadmin4 data browsing

От
Andrew Protasov
Дата:
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 <aditya.toshniwal@enterprisedb.com>
Sent: Wednesday, May 7, 2025 6:06 AM
To: Andrew Protasov <a_protasov@hotmail.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
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 <a_protasov@hotmail.com> 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
"Don't Complain about Heat, Plant a TREE"

Re: pgadmin4 data browsing

От
Lutz Badenheuer
Дата:
Hello,

Am Mittwoch, 7. Mai 2025, 13:06:02 CEST schrieb Aditya Toshniwal:
> 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.

Maybe this is about the amount of data? 

All the best, 
Luke