Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk0oZ-0008Qz-Fb for pgadmin-hackers@arkaria.postgresql.org; Thu, 17 Jan 2019 06:06:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gk0oY-0003P2-34 for pgadmin-hackers@arkaria.postgresql.org; Thu, 17 Jan 2019 06:06:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk0oX-0003M8-Oz for pgadmin-hackers@lists.postgresql.org; Thu, 17 Jan 2019 06:06:05 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk0oT-00062a-6j for pgadmin-hackers@postgresql.org; Thu, 17 Jan 2019 06:06:04 +0000 Received: by mail-ot1-x32f.google.com with SMTP id w25so10058559otm.13 for ; Wed, 16 Jan 2019 22:06:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=IdvAngHQe1XmRpNu8ggzx9BvqLdoIvJKuGciq0iQ9Mo=; b=rI/adoUfcHAa7SaGPU4+dn9WiA5tHXrq2ENin7VNFjDeg3QZgwsrjK0h4VkriMGDJz iXD+o9wjX+dAVyIyQeKCqp15J9nl1z2+iX6cSlhaZhGeKp+ZtUaSSD0earHapsMjCrtY uPUlVjhuGW2IKPc13xy9PR1zcOjAdE0McLDFIi6f0qPd4MvlJfI96tmIGqXnL7g0zSWw rQu+ZIX3p1CQyG5vErD6aIWiks76afPQ2W4mdmpUAnGW82V2elIpBRvhnluzvsADfnvL pLUBRfEwr7idu/Gi+8GXVHFVnB2YciDQ15KOz0u8DgAirO7XBXPtNDp9rTUng6CR5Y/w alAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=IdvAngHQe1XmRpNu8ggzx9BvqLdoIvJKuGciq0iQ9Mo=; b=pCSTHLup5Q70SKR7EM9iaXvaB2GIPeBgPVMOQ4L8XsuQ10mSpLQoB/+tF6TNzzJsDQ RquyHlzyu9f4SIHw6iZjK8YC9ei0oPxvBumueir+LelbvZ5vdjUD4EDBO1PZYj1IOIEd cZvx9sKIJl1ZCz4XOonpsQ4gDePf/eSwpYwF+DsGYN6QU0f0rdY/ZmMfPiQ9bazb+8dK W7o4hKZa/ff+gNR7h2R0Mn7EAwuDzGcvfm9yZ9NyzAw9gNsjplQEmtc6fME8ngi6ZahP 4v0aMBm9KfrIbb9xlTduxy/40SbyhTKOkLct8wBChp+aTzyWf+u3NyZFpbAs2VwDi4k5 /FrQ== X-Gm-Message-State: AJcUukdsvxpZuaq0dQ6obz17xpBdIcDdFUoJEircKoT3CcL0StA4fzNP IiKnVVT93HxfgyQosAK4rTidgWjXtBnQWDNvIP3pyI2p7W8/qg== X-Google-Smtp-Source: ALg8bN5DAIDOgUn9V5wP6cMC76gjheHSDRAq7+w4wfTNx67IwvS6qJ4m/PZTMH1hQnhgdLqeav5RTe7JBGcdQF0JfVc= X-Received: by 2002:a9d:751a:: with SMTP id r26mr7966835otk.273.1547705158807; Wed, 16 Jan 2019 22:05:58 -0800 (PST) MIME-Version: 1.0 From: Khushboo Vashi Date: Thu, 17 Jan 2019 11:35:48 +0530 Message-ID: Subject: [pgAdmin4][Patch] - RM 3664 - Statistic panel hangs when 1000+ tables To: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000003578c8057fa13047" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000003578c8057fa13047 Content-Type: multipart/alternative; boundary="0000000000003578c3057fa13045" --0000000000003578c3057fa13045 Content-Type: text/plain; charset="UTF-8" Hi, Please find the attached patch to fix the RM 3664 - Statistic panel hangs when 1000+ tables The statistics tab hangs with more rows. So, now the rows will be pushed in the backgrid collection in bunches on scroll event to fix this issue. Thanks, Khushboo --0000000000003578c3057fa13045 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Please find the attached patch to f= ix the RM 3664 - Statistic panel hangs when 1000+ tables

The statistics tab hangs with more rows. So, now the rows will be pu= shed in the backgrid collection in bunches on scroll event to fix this issu= e.

Thanks,
Khushboo
--0000000000003578c3057fa13045-- --0000000000003578c8057fa13047 Content-Type: application/octet-stream; name="RM_3664.patch" Content-Disposition: attachment; filename="RM_3664.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_jr07nt100 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL21pc2Mvc3RhdGlzdGljcy9zdGF0aWMvanMvc3RhdGlz dGljcy5qcyBiL3dlYi9wZ2FkbWluL21pc2Mvc3RhdGlzdGljcy9zdGF0aWMvanMvc3RhdGlzdGlj cy5qcwppbmRleCBjZmQ1NzNlMS4uZDAxZDVjMTUgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL21p c2Mvc3RhdGlzdGljcy9zdGF0aWMvanMvc3RhdGlzdGljcy5qcworKysgYi93ZWIvcGdhZG1pbi9t aXNjL3N0YXRpc3RpY3Mvc3RhdGljL2pzL3N0YXRpc3RpY3MuanMKQEAgLTExNyw3ICsxMTcsNyBA QCBkZWZpbmUoJ21pc2Muc3RhdGlzdGljcycsIFsKICAgICAgIF8uYmluZEFsbCgKICAgICAgICAg dGhpcywKICAgICAgICAgJ3Nob3dTdGF0aXN0aWNzJywgJ3BhbmVsVmlzaWJpbGl0eUNoYW5nZWQn LAotICAgICAgICAnX19jcmVhdGVNdWx0aUxpbmVTdGF0aXN0aWNzJywgJ19fY3JlYXRlU2luZ2xl TGluZVN0YXRpc3RpY3MnKTsKKyAgICAgICAgJ19fY3JlYXRlTXVsdGlMaW5lU3RhdGlzdGljcycs ICdfX2NyZWF0ZVNpbmdsZUxpbmVTdGF0aXN0aWNzJywgJ19fbG9hZE1vcmVSb3dzJyk7CiAKICAg ICAgIF8uZXh0ZW5kKAogICAgICAgICB0aGlzLCB7CkBAIC0yNTMsMTAgKzI1MywyMiBAQCBkZWZp bmUoJ21pc2Muc3RhdGlzdGljcycsIFsKICAgICAgICAgICAgIGNsZWFyVGltZW91dCh0aW1lcik7 CiAgICAgICAgICAgICAkbXNnQ29udGFpbmVyLnRleHQoJycpOwogICAgICAgICAgICAgaWYgKHJl cy5kYXRhKSB7Ci0gICAgICAgICAgICAgIHZhciBkYXRhID0gcmVzLmRhdGE7CisgICAgICAgICAg ICAgIHZhciBkYXRhID0gc2VsZi5kYXRhID0gcmVzLmRhdGE7CiAgICAgICAgICAgICAgIGlmIChu b2RlLmhhc0NvbGxlY3RpdmVTdGF0aXN0aWNzIHx8IGRhdGFbJ3Jvd3MnXS5sZW5ndGggPiAxKSB7 CisgICAgICAgICAgICAgICAgLy8gTGlzdGVuIHNjcm9sbCBldmVudCB0byBsb2FkIG1vcmUgcm93 cworICAgICAgICAgICAgICAgIHBnQnJvd3Nlci5FdmVudHMub24oCisgICAgICAgICAgICAgICAg ICAncGdhZG1pbi1icm93c2VyOnBhbmVsLXN0YXRpc3RpY3M6JyArCisgICAgICAgICAgICAgICAg ICB3Y0RvY2tlci5FVkVOVC5TQ1JPTExFRCwKKyAgICAgICAgICAgICAgICAgIHNlbGYuX19sb2Fk TW9yZVJvd3MKKyAgICAgICAgICAgICAgICApOwogICAgICAgICAgICAgICAgIHNlbGYuX19jcmVh dGVNdWx0aUxpbmVTdGF0aXN0aWNzLmNhbGwoc2VsZiwgZGF0YSwgbm9kZS5zdGF0c1ByZXR0aWZ5 RmllbGRzKTsKICAgICAgICAgICAgICAgfSBlbHNlIHsKKyAgICAgICAgICAgICAgICAvLyBEbyBu b3QgbGlzdGVuIHRoZSBzY3JvbGwgZXZlbnQKKyAgICAgICAgICAgICAgICBwZ0Jyb3dzZXIuRXZl bnRzLm9mZigKKyAgICAgICAgICAgICAgICAgICdwZ2FkbWluLWJyb3dzZXI6cGFuZWwtc3RhdGlz dGljczonICsKKyAgICAgICAgICAgICAgICAgIHdjRG9ja2VyLkVWRU5ULlNDUk9MTEVELAorICAg ICAgICAgICAgICAgICAgc2VsZi5fX2xvYWRNb3JlUm93cworICAgICAgICAgICAgICAgICk7CiAg ICAgICAgICAgICAgICAgc2VsZi5fX2NyZWF0ZVNpbmdsZUxpbmVTdGF0aXN0aWNzLmNhbGwoc2Vs ZiwgZGF0YSwgbm9kZS5zdGF0c1ByZXR0aWZ5RmllbGRzKTsKICAgICAgICAgICAgICAgfQogCkBA IC0zODYsNyArMzk4LDE0IEBAIGRlZmluZSgnbWlzYy5zdGF0aXN0aWNzJywgWwogCiAgICAgICB9 CiAKLSAgICAgIHRoaXMuY29sbGVjdGlvbi5yZXNldChyb3dzKTsKKyAgICAgIHRoaXMuY29sbGVj dGlvbi5yZXNldChyb3dzLnNwbGljZSgwLCA1MCkpOworICAgIH0sCisKKyAgICBfX2xvYWRNb3Jl Um93czogZnVuY3Rpb24oZGF0YSwgcHJldHRpZnlGaWVsZHMpIHsKKyAgICAgIHZhciByb3dzID0g dGhpcy5kYXRhWydyb3dzJ107CisgICAgICAgIGlmIChyb3dzLmxlbmd0aCA+IDApIHsKKyAgICAg ICAgICB0aGlzLmNvbGxlY3Rpb24uYWRkKHJvd3Muc3BsaWNlKDAsIDUwKSk7CisgICAgICAgIH0K ICAgICB9LAogCiAgICAgX19jcmVhdGVTaW5nbGVMaW5lU3RhdGlzdGljczogZnVuY3Rpb24oZGF0 YSwgcHJldHRpZnlGaWVsZHMpIHsK --0000000000003578c8057fa13047--