Re: 1-2 second delay on all commands over network - Mailing list pgsql-novice

From Andrew McMillan
Subject Re: 1-2 second delay on all commands over network
Date
Msg-id 1067855828.4572.779.camel@kant.mcmillan.net.nz
Whole thread Raw
In response to 1-2 second delay on all commands over network  (chameenz@yahoo.com (Matthew Cimino))
List pgsql-novice
On Sat, 2003-11-01 at 09:06, Matthew Cimino wrote:
> I am coding a small Visual Basic app using ODBC and ADO to connect to
> a Postgres 7.3 database running on a RedHat 9 server. The issue I am
> having is a small delay of 1-2 seconds for every command I issue in
> the application. 2 seconds to connect then 2 seconds to query...about
> 2 seconds with every command. The app has a few simple queries when it
> starts but takes a solid 10 seconds to first open because of these
> delays.
>
> The server is already being using as a web server and the speeds on
> the queries that PHP makes is great.
>
> Any suggestions would be greatly appreciated.

What does pg_hba.conf look like?  It is possible that it is trying to do
an ident lookup, failing that, and falling back to password or
something.

Cheers,
                    Andrew.
-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053,  Manners St,  Wellington
WEB: http://catalyst.net.nz/             PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201       MOB: +64(21)635-694      OFFICE: +64(4)499-2267
       The secret of being a bore is to say everything - Voltaire
-------------------------------------------------------------------------

pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: SQL question
Next
From: "D. Spoon"
Date:
Subject: OT: OS/distribution recommendations