Re: Speed

> -----Original Message-----
> From: fred@ontosys.com [mailto:fred@ontosys.com]
> Sent: 19 December 2001 23:01
> To: Andy Pearce
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Speed
>
>
> On Wed, Dec 19, 2001 at 10:08:37PM -0000, Andy Pearce wrote:
> > I've been using pgAdmin for sometime now and find it to be a very
> > useful tool. The only problem i've come across is that it is really
> > slow when accessing the server.
>
> I've just started using SSH tunneling to connect pgAdmin II
> to a remote server and find that the SSH compression cuts the
> first delay (response to clicking on 'Databases' in the left
> panel) from 18sec to about 8sec.

Hi Fred,

That's some change - are you working across a dialup link?

Just for info, that initial delay occurs because when you click Databases,
the pgSchema library queries the master connection database (usually
template1) for a list of databases, then opens a connection to each one and
retrieves it's comment. When we move into the v1.3 development code
(probably beginning of Jan) one of the things I want to look at is caching
those comments so the database connection is only opened if you actually
double click on a database.

Regards, Dave.