Re: [RM2522] Improve grid/column select all operation
| От | Harshal Dhumal |
|---|---|
| Тема | Re: [RM2522] Improve grid/column select all operation |
| Дата | |
| Msg-id | CAFiP3vy-7yjLqzPfbKzrNj_tJd4p7vB0Sjiq0vusVpRHS3FoJg@mail.gmail.com обсуждение исходный текст |
| Ответ на | [RM2522] Improve grid/column select all operation (Harshal Dhumal <harshal.dhumal@enterprisedb.com>) |
| Ответы |
Re: [RM2522] Improve grid/column select all operation
|
| Список | pgadmin-hackers |
On Thu, Jun 29, 2017 at 4:33 PM, Harshal Dhumal <harshal.dhumal@enterprisedb.com> wrote:
Hi,Please find attached patch for RM2522.With this patch grid/column select all time is reduce to ~1 second from 8-10 seconds.
This benchmarking is performed with 100k rows and 2 columns (int, text).
The solution was to use simple array concatenation instead of underscore union while getting index of all selected complete rows.Underscore union function is only useful when user selects different ranges from grid and those ranges overlaps. In this case union function removes duplicate (overlapped) rows.However result grid in sqleditor do not support overlapped row selection so we can simply cancat rows from different ranges without worrying about overlapped row selection.--Harshal DhumalSr. Software Engineer
В списке pgadmin-hackers по дате отправления: