Re: Performance of pgAdmin 14 Beta 1 - Mailing list pgadmin-support

From Dave Page
Subject Re: Performance of pgAdmin 14 Beta 1
Date
Msg-id BANLkTimqENYVb=GYxWTh_7bTOOLtQa5M3g@mail.gmail.com
Whole thread Raw
In response to Re: Performance of pgAdmin 14 Beta 1  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support
On Thu, Jun 2, 2011 at 11:29 AM, Dave Page <dpage@pgadmin.org> wrote:
> On Thu, Jun 2, 2011 at 9:46 AM, Kieran McCusker
> <kieran.mccusker@kwest.info> wrote:
>> If we cannot go back to lazy loading these tabs would it be possible to
>> disable or hide these tabs and the corresponding querys in File ->
>> Options (similar to the browser tab or maybe a general "simple mode"
>> type idea).
>
> I'll look into it.

I figured out a way of detecting if a tab is visible, regardless of
whether it is currently selected, so with that info we can ensure we
only load the listviews that are currently visible (or are about to
become visible, if the tabset selection is changing). I also realised
that we were loading the three most expensive tabs twice every time
the selected object was changed(!), so even if all tabs are visible it
should be twice as fast as it was now.

I also cleaned up the code that does this, as it had become somewhat
spaghetti-like, and had duplication in a number of code paths.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


pgadmin-support by date:

Previous
From: "Belbin, Peter"
Date:
Subject: Re: Pgadmin III loses connection with remote database and then hangs for a long time.
Next
From: Ben Carbery
Date:
Subject: Re: pg_listener table errors with slony