From: | Rodger Haynes <rodger(at)thompsonprint(dot)com> |
---|---|
To: | Michiel_Lange(at)actuera(dot)nl, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Speed |
Date: | 2002-10-09 20:08:10 |
Message-ID: | 3DA48CAA.1040607@thompsonprint.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I don't know how big your database is, but I have one with 23 tables of
varying sizes, the largest of which is 25,000 records. Each step in the
hierarchy, ie open connection, open database, open table, takes about 2
seconds. My server is a Dell P3 600mz and my client is a Dell P3
400mz. I use the same pgAdmin, but Postgres 7.2.1. Are you running any
other protocols besides tcp/ip?
Michiel_Lange(at)actuera(dot)nl wrote:
>Fellow pgAdministrators,
>
>Shortly I went trying to use pgAdmin. I know pgAdmin uses ODBC, and I know
>that it is not the quickest form of connection you can get.
>I can live with that... but I wondered if any of you is experiencing this
>kind of performance as well, or have experienceD, and know a solution ;-)
>
>Connecting itself takes 5 seconds (I can live with that, no problem)
>Clicking on 'Databases' makes me wait at least 10 minutes (I have only one
>database of my own, aside the default databases) I cannot live with that...
>Listing the tables takes another 10 minutes at least etc etc... everything
>just takes ages...
>
>I really do not exaggerate, and think there ought to be a way to fix it...
>I have:
>pgAdmin 1.2.0 with databases on Postgres 7.2.2
>Today I upgraded pgODBC, but that did not really help... anyone?
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-10-10 07:49:39 | Re: Speed |
Previous Message | Michiel_Lange | 2002-10-09 15:01:53 | Speed |