Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uCcbr-00HYSD-Fd for pgadmin-support@arkaria.postgresql.org; Wed, 07 May 2025 11:06:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uCcbq-00DcDY-HH for pgadmin-support@arkaria.postgresql.org; Wed, 07 May 2025 11:06:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uCcbq-00DcDQ-8v for pgadmin-support@lists.postgresql.org; Wed, 07 May 2025 11:06:42 +0000 Received: from mail-qv1-xf30.google.com ([2607:f8b0:4864:20::f30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uCcbm-000Zw1-1I for pgadmin-support@lists.postgresql.org; Wed, 07 May 2025 11:06:40 +0000 Received: by mail-qv1-xf30.google.com with SMTP id 6a1803df08f44-6f0ad744811so56601736d6.1 for ; Wed, 07 May 2025 04:06:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1746615998; x=1747220798; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=5/wE0zotjgdcodhSlQOQP/PnD2/UkpHRfLsjpuEcG3k=; b=GdbYYV0nq1Di36aTdYORYp93x9nF9X2VArjyBZFwwGdU2gL30l5iioxJh601s9BM/f kVAyQSGNquFoPUwkpPdFtPQeKmpv4gM3ACmdUvziX9md6h2oUW9FjP+PxVqRNDA0rqC8 vfPsrwNPqNEnwNBC/HhSxsHQ4ZzjB6gOhENzhAazfZh8hHiz9nStYcLCOk1I2exmHcqv 9pssgbzHuR3zOrzW8LWtylQIHnRS6AFWXYHMPkZi12KDh9QkNmBQALbjkIK96LR0N3sP RHNPGHEIrnbCnjWyLtKt6ZRh1CbpDWdsekRoRKocwgVw3DGwUkmVTHZ/3qqytkKfpv/a UBGA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746615998; x=1747220798; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=5/wE0zotjgdcodhSlQOQP/PnD2/UkpHRfLsjpuEcG3k=; b=GKUN2eqbRxRQpfF7u2K5Lxz0DjuzTRrRvCc3Y1DHXKz45yh2nMtQqm0xq8yaa4eVff gawg/G/SNIh8MBT5RWWBv35pZE5vRSOVzbnl6lSwmyR6vfXt08g4MDpH6Y6K+dLrLosi dW/2o4moMkrUVNdYhRp2BHQrGOBRWm81gkY7h7h3uXk09nv1+iIKLvcu1s7vfPxrlY1f l0BRFMbHPpd1dlPGCumSkKGssHfobssEpiUssdh2i9eBIdhcKFnx5XVwAT7VUPOHZn7s 5lrxIAWu5tC+Yzqq2RQ+c5CPpaAOb1Die13h7KEiJTZybNzLxcv0VWzW4fxFeT8340ri wRMg== X-Gm-Message-State: AOJu0Ywo6hThej1PZ8qlNT4cagvBji7akfeXbkKcd4wMDZbMPqw3czcU JxDvydcpyheiki8jQK/5nUcEA7RDa6VEhsDB4mqgrsB/xdcBRIa4X1grlfWJzqq+ogvJ9Kn2jGG zyYCldDTwwuDoY8rJldStRrGq+XjNqKGvDoTU X-Gm-Gg: ASbGncvfaGLewEUREVgER/voS13IS4w9FQpB/W8VT5itBuoEEgH5ZuB6ZwqbDSJRY0P WNF54FpryV44EPLpuQbCwP+qvZue7XVCC83QrfgMCkpQbU+EQgnCTUeNuUThu3VDqZ8irhG/aR4 nIqy9H6dYf2f2ovrFxMuIjz8wrH7kNPXnQ2UhhUEk8LiK/uZQbQofSDQE= X-Google-Smtp-Source: AGHT+IFspIGL4tPSWoNnnY3OQG4rt5xIHnu3kVE4hdtyaShlMr1OVA7eAC4/TMZto3yV0PAmx2T+23RBtIfQniSgKfk= X-Received: by 2002:a05:6214:529a:b0:6f2:c81f:9ef9 with SMTP id 6a1803df08f44-6f542ac14f5mr36370326d6.33.1746615997804; Wed, 07 May 2025 04:06:37 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Wed, 7 May 2025 16:36:02 +0530 X-Gm-Features: ATxdqUG6I_IgFBXQ1TDrC9XcRynJj8XuUACZelSK3vc73BOQuc81KK7QMjB_NfM Message-ID: Subject: Re: pgadmin4 data browsing To: Andrew Protasov Cc: "pgadmin-support@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000001bcd19063489ba1a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001bcd19063489ba1a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFPM Andrew Protasov wrote: > Hi, > > Browsing of query result set using page up/page down keys is very slow an= d > 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 > > --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --0000000000001bcd19063489ba1a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Andrew,

We're already using react-data-grid which u= ses virtualization and is quite fast. You might be using an older version w= here the data was fetched from the server dynamically on scroll.

On Wed, May 7, 2025 at 4:00=E2=80=AFPM Andrew Protasov <= ;a_protasov@hotmail.com> w= rote:
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 wi= dget like slickgrid for it, which has decent performance. Pgadmin3 did not = have this issue at all.

Andrew



--
Thanks,
Aditya T= oshniwal
pgAdmin Hacker=C2=A0| Sr. Staff SDE II=C2=A0| enterprisedb.com=
"Don't Complain about Heat, Plant a TREE"
--0000000000001bcd19063489ba1a--