public inbox for [email protected]
help / color / mirror / Atom feedFrom: Aditya Toshniwal <[email protected]>
To: Edson Richter <[email protected]>
Cc: pgAdmin Support <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Cc: Dave Page <[email protected]>
Subject: Re: Query tool data grid - Infinite scroll vs Pagination
Date: Fri, 28 Jun 2024 22:12:16 +0530
Message-ID: <CAM9w-_nL+mFa5vFzrrkBsEmXfN-jKp6X_DwAkjaqmnZMVGg1gQ@mail.gmail.com> (raw)
In-Reply-To: <CPVP215MB1823D401127C6071F7D2F39FCFD02@CPVP215MB1823.LAMP215.PROD.OUTLOOK.COM>
References: <CAM9w-_mJkHpqE2BSdBsLqOVO4ARaWPDXZGYb5Hn3eMh+sDcOrg@mail.gmail.com>
<CA+OCxozbRmSmRytM2_4_gNvbpqrX0fEyfFVzYPVWH8ftxHchrQ@mail.gmail.com>
<CAM9w-_n6Eo2SBPMjF-SD1NoWD7_RkhKk+=bPC4sYf3QYOP1wog@mail.gmail.com>
<CAM9w-_n2zyK-fGYKedi59Z_t3-6LTfZeD0_Bgz4EWXhrS6=Zuw@mail.gmail.com>
<CPVP215MB1823D401127C6071F7D2F39FCFD02@CPVP215MB1823.LAMP215.PROD.OUTLOOK.COM>
Hi Edson,
The current implementation is infinite scroll. We're planning to
replace/improve it.
On Fri, Jun 28, 2024 at 6:48 PM Edson Richter <[email protected]>
wrote:
> Infinite scroll usually consume a lot of memory, and generate additional
> overhead in case of copy data, export, etc. In my humble opinion, if
> anything then paginated would work better without additional memory
> consumption.
> In case of implementing infinite scroll, please give users a option to
> disable it.
>
> Thanks,
>
> Edson
>
> Obter o Outlook para Android <https://aka.ms/AAb9ysg;
> ------------------------------
> *From:* Aditya Toshniwal <[email protected]>
> *Sent:* Friday, June 28, 2024 5:33:45 AM
> *To:* pgAdmin Support <[email protected]>
> *Cc:* pgadmin-hackers <[email protected]>; Dave Page <
> [email protected]>
> *Subject:* Re: Query tool data grid - Infinite scroll vs Pagination
>
> Hi,
>
> Unfortunately, there were only 3 responses to this.
> In that case, we will discuss internally and decide what to do.
>
> On Thu, Jun 20, 2024 at 2:46 PM Aditya Toshniwal <
> [email protected]> wrote:
>
> Hi Everyone,
>
> Request you to share your opinion on this and respond on:
>
> https://docs.google.com/forms/d/e/1FAIpQLSdfJhNK8qXSe9mKcubZa8jjjYl0hiZVxhv6GGJo8WJcYc27ug/viewform?...
>
> On Thu, Jun 20, 2024 at 1:36 PM Dave Page <[email protected]> wrote:
>
> Hi
>
> On Wed, 19 Jun 2024 at 13:42, Aditya Toshniwal <
> [email protected]> 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
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/;
> "Don't Complain about Heat, Plant a TREE"
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/;
> "Don't Complain about Heat, Plant a TREE"
>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *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], [email protected]
Subject: Re: Query tool data grid - Infinite scroll vs Pagination
In-Reply-To: <CAM9w-_nL+mFa5vFzrrkBsEmXfN-jKp6X_DwAkjaqmnZMVGg1gQ@mail.gmail.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