| From: | Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com> |
|---|---|
| To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | PATCH: To fix the performance of delete operation (pgAdmin4) |
| Date: | 2016-09-15 10:08:09 |
| Message-ID: | CAKKotZQvEXHC_z76muv0V+f--Uskph1Oj3WHB5PfPxS2MEgHUA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| RM_1696.patch | application/octet-stream | 5.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Surinder Kumar | 2016-09-15 10:21:34 | [pgAdmin4][Patch]: RM1669 - Cannot remove nor change length definition on column in "The Table Dialog" |
| Previous Message | Surinder Kumar | 2016-09-15 09:24:21 | Re: [pgAdmin4][Patch]: RM1579 - Unable to scroll the query text window during selection |