pgAdmin 4 commit: Improved performance while fetching edit types for ea

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: pgAdmin 4 commit: Improved performance while fetching edit types for ea
Date: 2019-12-16 13:20:38
Message-ID: E1igqIg-0005mV-6R@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)toshniwal(at)enterprisedb(dot)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(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2019-12-16 13:24:36 Re: [pgAdmin][RM4988] Refactoring of all the SQL files used by pgAdmin4
Previous Message Aditya Toshniwal 2019-12-16 12:09:37 [pgAdmin][RM4988] Refactoring of all the SQL files used by pgAdmin4