From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Query tool data grid - Infinite scroll vs Pagination |
Date: | 2024-06-20 08:06:25 |
Message-ID: | CA+OCxozbRmSmRytM2_4_gNvbpqrX0fEyfFVzYPVWH8ftxHchrQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgadmin-support |
Hi
On Wed, 19 Jun 2024 at 13:42, Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
> Hi Hackers,
>
> Query tool data grid currently pulls the data on load basis in batches.
> For example, it will initially load only 1000 rows and once a user scrolls
> to the 1000th row, it will fetch the next batch of 1000.
> Many users who want access in between rows or last row struggle to do it
> as the user has to scroll and scroll. If someone grabs the scroller and
> pulls it down still it will be a good UX and the scrollbar may jump. One
> reported here - https://github.com/pgadmin-org/pgadmin4/issues/1780
> One more aspect to this is the in memory data of the query tool which keep
> on increasing on each scroll, it affects the performance.
>
> I propose we should use pagination instead of infinite scroll with the
> following advantages:
> 1. Users can jump to any page they want.
> 2. Users can change the page size on the grid directly.
> 3. Memory will be used only for visible rows so performance improvement.
> 4. Predictable UI, no jumping scrollbars.
>
> Let me know what you think.
>
I think there are definite benefits, but there is the downside of having to
scroll and click to browse results. Personally I'm fine with that, but I
think you should probably poll pgadmin-support for opinions from more users.
--
Dave Page
pgAdmin: https://www.pgadmin.org
PostgreSQL: https://www.postgresql.org
EDB: https://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2024-06-20 09:16:34 | Re: Query tool data grid - Infinite scroll vs Pagination |
Previous Message | Aditya Toshniwal | 2024-06-19 12:41:19 | Query tool data grid - Infinite scroll vs Pagination |
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2024-06-20 09:16:34 | Re: Query tool data grid - Infinite scroll vs Pagination |
Previous Message | Aditya Toshniwal | 2024-06-19 12:41:19 | Query tool data grid - Infinite scroll vs Pagination |