Re: Beta 1.6: Output Headers refresh in slow motion

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Harald Armin
Massa
Sent: 15 September 2006 15:08
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Beta 1.6: Output Headers refresh in
slow motion


I am totally fascinated with 1.6 ... and do more and more
queries in that joyfull Query window!

The "underlining of the errornous character" is really a big
help for small typing misstakes, GREAT!

On the Data Output grid, something could be better: those grey
column headers get refreshed in slow motion.

It happens when I switch pgadmin to the background and then back
to the foreground ... they blob in one after the other, with a clear
recognizable delay between each.

Also with queries with bigger result sets from distant (as in
WAN) server: data rather flashes into the grid, but the headers drop in
one by one; as if every header has to be confirmed by at least 1 core
developer.

It seems to get slower over time ... that is with more
concurrently open output panes or longer runtime of pgadmin; but that is
not confirmed yet.

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.

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.

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

Regards, Dave.