public inbox for [email protected]
help / color / mirror / Atom feedpgadmin4 data browsing
5+ messages / 4 participants
[nested] [flat]
* pgadmin4 data browsing
@ 2025-05-07 01:30 Andrew Protasov <[email protected]>
2025-05-07 10:40 ` Re: pgadmin4 data browsing Ray O'Donnell <[email protected]>
2025-05-07 11:06 ` Re: pgadmin4 data browsing Aditya Toshniwal <[email protected]>
0 siblings, 2 replies; 5+ messages in thread
From: Andrew Protasov @ 2025-05-07 01:30 UTC (permalink / raw)
To: [email protected] <[email protected]>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgadmin4 data browsing
2025-05-07 01:30 pgadmin4 data browsing Andrew Protasov <[email protected]>
@ 2025-05-07 10:40 ` Ray O'Donnell <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Ray O'Donnell @ 2025-05-07 10:40 UTC (permalink / raw)
To: Andrew Protasov <[email protected]>; [email protected] <[email protected]>
On 07/05/2025 02:30, Andrew Protasov wrote:
> 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.
>
I have to say that's not my experience here (version 9.3 on Kubuntu
24.04) - it's very fast and responsive. Granted, the server is running
on the same machine; so if you are fetching a lot of data from a remote
server perhaps you are seeing network latency.
Ray.
--
Raymond O'Donnell // Galway // Ireland
[email protected]
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgadmin4 data browsing
2025-05-07 01:30 pgadmin4 data browsing Andrew Protasov <[email protected]>
@ 2025-05-07 11:06 ` Aditya Toshniwal <[email protected]>
2025-05-07 20:01 ` Re: pgadmin4 data browsing Andrew Protasov <[email protected]>
2025-05-08 00:25 ` Re: pgadmin4 data browsing Lutz Badenheuer <[email protected]>
1 sibling, 2 replies; 5+ messages in thread
From: Aditya Toshniwal @ 2025-05-07 11:06 UTC (permalink / raw)
To: Andrew Protasov <[email protected]>; +Cc: [email protected] <[email protected]>
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]>
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"
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgadmin4 data browsing
2025-05-07 01:30 pgadmin4 data browsing Andrew Protasov <[email protected]>
2025-05-07 11:06 ` Re: pgadmin4 data browsing Aditya Toshniwal <[email protected]>
@ 2025-05-07 20:01 ` Andrew Protasov <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Andrew Protasov @ 2025-05-07 20:01 UTC (permalink / raw)
To: Aditya Toshniwal <[email protected]>; +Cc: [email protected] <[email protected]>
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"
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgadmin4 data browsing
2025-05-07 01:30 pgadmin4 data browsing Andrew Protasov <[email protected]>
2025-05-07 11:06 ` Re: pgadmin4 data browsing Aditya Toshniwal <[email protected]>
@ 2025-05-08 00:25 ` Lutz Badenheuer <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Lutz Badenheuer @ 2025-05-08 00:25 UTC (permalink / raw)
To: [email protected]
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2025-05-08 00:25 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-07 01:30 pgadmin4 data browsing Andrew Protasov <[email protected]>
2025-05-07 10:40 ` Ray O'Donnell <[email protected]>
2025-05-07 11:06 ` Aditya Toshniwal <[email protected]>
2025-05-07 20:01 ` Andrew Protasov <[email protected]>
2025-05-08 00:25 ` Lutz Badenheuer <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox