From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'fred(at)ontosys(dot)com'" <fred(at)ontosys(dot)com>, Andy Pearce <andyj(at)interra(dot)demon(dot)co(dot)uk> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Speed |
Date: | 2001-12-20 08:15:52 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB104739D@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: fred(at)ontosys(dot)com [mailto:fred(at)ontosys(dot)com]
> Sent: 19 December 2001 23:01
> To: Andy Pearce
> Cc: pgadmin-support(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter E. Chen | 2001-12-20 15:55:14 | |
Previous Message | Dave Page | 2001-12-20 08:09:11 | Re: Speed |