Re: Beta 1.6: Output Headers refresh in slow motion - Mailing list pgadmin-support

From Harald Armin Massa
Subject Re: Beta 1.6: Output Headers refresh in slow motion
Date
Msg-id 7be3f35d0609150857rfb180f2se769da237e428ea8@mail.gmail.com
Whole thread Raw
In response to Re: Beta 1.6: Output Headers refresh in slow motion  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: Beta 1.6: Output Headers refresh in slow motion
List pgadmin-support

Same "slow motion" is happening on resizing the output pane panel. 
 
What's happening is that when the grid control redraws itself, it asks the dataset what the header labels should be. The dataset then queries the database to get the correct typename (because libpq's PGresult only stores the type OIDs) for each column.

Hmmm.... isn't the relation type OID -> type fixed for every given instance of a database?
Maybe it would be even quicker to have a local cache of

typeOID -> typeName

So even new queries will get their column headers quick.
 
>I've committed a fix that will cache the type names as they are requested so that after the >initial display, subsequent redraws won't cause any queries to be sent to the backend.

Thats fine.
Of course, this behaviour doesn't show up on a fast PC running the server on localhost :-)

Aaaah... now I know why with at 1600 (4pm) that redraw grew faster ... most people left the office, so the WAN was more responsive :)

Thanks for caching,

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Let's set so double the killer delete select all.

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Beta 1.6: Output Headers refresh in slow motion
Next
From: "Dave Page"
Date:
Subject: Re: Beta 1.6: Output Headers refresh in slow motion