pgAdmin 4 commit: Improved performance while fetching edit types for ea - Mailing list pgadmin-hackers

From Akshay Joshi
Subject pgAdmin 4 commit: Improved performance while fetching edit types for ea
Date
Msg-id E1igqIg-0005mV-6R@gothos.postgresql.org
Whole thread Raw
List pgadmin-hackers
Improved performance while fetching edit types for each column.

Edit types query is executed for every column when open properties dialog of the table.
Change the logic to fetch the edit types for all the distinct column types used in the table at once.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ded71be73f219884fe3e4a21adc7aef8fb630764
Author: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>

Modified Files
--------------
.../databases/schemas/tables/columns/__init__.py   |  5 ++-
.../databases/schemas/tables/columns/utils.py      | 37 ++++++++++++----------
.../columns/sql/default/edit_mode_types_multi.sql  | 13 ++++++++
.../columns/sql/default/is_referenced.sql          |  6 ----
4 files changed, 37 insertions(+), 24 deletions(-)


pgadmin-hackers by date:

Previous
From: Aditya Toshniwal
Date:
Subject: [pgAdmin][RM4988] Refactoring of all the SQL files used by pgAdmin4
Next
From: Akshay Joshi
Date:
Subject: Re: [pgAdmin][RM4988] Refactoring of all the SQL files used by pgAdmin4