Kenneth Downs wrote:
Dave Page wrote:
------------------------------------------------------------------------
*From:* pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] *On Behalf Of
*Kenneth Downs
*Sent:* 12 May 2006 02:09
*To:* pgsql-general@xxxxxxxxxxxxxx
*Subject:* Re: [GENERAL] GUI Interface
The longer you use it, the longer it takes to connect to
databases each time you start up. It says "Restoring previous
settings".
It should only take longer if the number of objects in your database
grows significantly, or if you've turned on debug logging. At that
point it is examining your database so that it can rebuild the
treeview to roughly the state that it was when you last used it.
My database has 270+ tables. That's probably small for where it will
be in a year. At the moment I have only a dozen or so databases per
server, and four servers that I regularly connect to. I did not
intentionally turn on debug logging.
Part of the problem is that pgAdmin III seems to preload object
properties instead of pulling them in as you need them.
I have noticed many times in pgAdmin III that when a function is edited
and saved by someone else on a different workstation I can't see those
changes until I manually
refresh the object. When you have a ton of tables etc that
preloading/caching has to be taking up some time.
PGLA only populates the tree with the object names, and when you double
click or right click to edit, then and only then is the object data
brought back and displayed.
When Lazarus(http://www.lazarus.freepascal.org/) becomes more stable I
will create a port of PGLA that will run on Linux and Mac OS X.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
