public inbox for [email protected]  

help / color / mirror / Atom feed

From: Zaid Shabbir <[email protected]>
To: Pravesh Sharma <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: Regarding issue #6510
Date: Tue, 20 May 2025 20:49:29 +0500
Message-ID: <CABCJe_UOGCZKQm5pY2rv8_WonP9ga-b2B3MXbBbDDOUv5pBFUg@mail.gmail.com> (raw)
In-Reply-To: <CA+36bxGb7qik5gphraXht9gVpRuWV1ttEB8F5sptW3WTq6SOrw@mail.gmail.com>
References: <CA+36bxGb7qik5gphraXht9gVpRuWV1ttEB8F5sptW3WTq6SOrw@mail.gmail.com>

Hello Pravesh

Nice implementation. In case someone wants to review the complete JSON, is
there a way to open the contents in a separate window (popup or side
window) on a click event? The entire larger string can be loaded on demand
when the click event is triggered.


Regards,
Zaid

On Tue, May 20, 2025 at 10:16 AM Pravesh Sharma <
[email protected]> wrote:

> Hi Hackers,
>
> I am working on issue #6510
> <https://github.com/pgadmin-org/pgadmin4/issues/6510;, where the result
> grid slows down and sometimes hangs when large JSON or text data is present
> in a table column. Upon investigation, I found that this is due to
> rendering the entire JSON to the DOM. This causes slowness, especially with
> large datasets; for example, rendering a 15MB JSON object for preview
> purposes is unnecessary. I am proposing a solution where the result grid
> will render data up to a certain length. I have implemented these changes,
> and everything is working fine, resulting in a significant performance
> improvement. As you can see in the screenshot, the JSON data is 20MB, and
> on the result grid, we are displaying only 200 characters as it is only a
> preview. I am also considering making this maximum display length a user
> preference, named "Max column data display length," allowing them to
> customize how much data they want to see. Can you tell me what you think of
> this approach or if you have any suggestions?
>
>
> Thanks,
>
> Pravesh
>
> [image: image.png]
> --
>
>
> Pravesh Sharma
>
> Senior SDE
>
> +91 9406461406
>
>
> enterprisedb.com
>


Attachments:

  [image/png] image.png (170.3K, 3-image.png)
  download | view image

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]
  Subject: Re: Regarding issue #6510
  In-Reply-To: <CABCJe_UOGCZKQm5pY2rv8_WonP9ga-b2B3MXbBbDDOUv5pBFUg@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