Re: PATCH: To fix the performance of delete operation (pgAdmin4)

From: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: To fix the performance of delete operation (pgAdmin4)
Date: 2016-09-16 11:34:18
Message-ID: CAKKotZSW7SsQ6StbcZHyOh68jwVF381=r=dH7hJyeUuNtCVpwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Dave,

Please find updated patch.

Regards,
Murtuza

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Fri, Sep 16, 2016 at 3:31 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Can you rebase this please?
>
> Thanks.
>
> On Thu, Sep 15, 2016 at 11:08 AM, Murtuza Zabuawala
> <murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
> > Hi,
> >
> > PFA patch to fix the issue of slow performance while deleting rows from
> > grid.
> > RM#1696
> >
> > Issue:
> > As per logic implemented for Backgrid, we were deleting individual rows,
> > means If user selects 100 rows to delete then we were rendering sql
> template
> > 100 times to generate sql for each individual rows and then execute all
> 100
> > delete statements one by one due to which we were getting poor
> performance.
> >
> > Please review.
> >
> > --
> > Regards,
> > Murtuza Zabuawala
> > EnterpriseDB: http://www.enterprisedb.com
> > The Enterprise PostgreSQL Company
> >
> >
> > --
> > Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgadmin-hackers
> >
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

Attachment Content-Type Size
RM_1696_v2.patch application/octet-stream 5.1 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Navnath Gadakh 2016-09-16 13:37:53 pgAdmin IV- Testing framework: Enhanced Test Result Summary
Previous Message Murtuza Zabuawala 2016-09-16 11:17:05 PATCH: To fix the isssue where several default privileges cause error (pgAdmin4)