[RM2522] Improve grid/column select all operation - Mailing list pgadmin-hackers

From Harshal Dhumal
Subject [RM2522] Improve grid/column select all operation
Date
Msg-id CAFiP3vwzh6SxGZ4sacg4c8o=RsDH-9-OC=_eYRaeu8R+9Ni-AA@mail.gmail.com
Whole thread Raw
Responses Re: [RM2522] Improve grid/column select all operation  (Harshal Dhumal <harshal.dhumal@enterprisedb.com>)
List pgadmin-hackers
Hi,

Please find attached patch for RM2522.

With this patch grid/column select all time is reduce to ~1 second from 8-10 seconds.

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 Dhumal
Sr. Software Engineer

EnterpriseDB India: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Attachment

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Tree view icon samples
Next
From: Harshal Dhumal
Date:
Subject: Re: [RM2522] Improve grid/column select all operation