Re: Slow Connection - Mailing list pgsql-interfaces

From M.Feldtmann@t-online.de (Marten Feldtmann)
Subject Re: Slow Connection
Date
Msg-id 3C55AD49.EAEE0489@toppoint.de
Whole thread Raw
In response to Slow Connection  (Achmad Amin <ma_achmad@yahoo.com>)
List pgsql-interfaces

Andreas Kretzer schrieb:
> 
> Achmad Amin schrieb:
> 
> > Dear all,
> > I develop application using Delphi and Postgres (use
> > Winzeos component to connect to postgres). But I have
> > problem, when I run application at first time, I wait
> > about 1 minute to see the application. I think this
> > happen because my application to connect to postgres
> > too slow. What I must do to reduce speed connection
> 
>                               ^^^^^^^^^^^^^ you mean increase?
> 
> > between my application to postgres ?
> 
> Well, often this behavior can result from a timed out
> name lookup (I assume you don't really have an official
> name for your client :-) To check this, try to 'telnet'
> to your server before you do anything else (so you will
> have the same situation). If this takes more than just
> one or two seconds - but succeeds after a while, perhaps
> the one minute delay you mentioned - then it probably is
> the name lookup. 
Even if the name lookup works ... it may be the reverse 
name lookup .... try to use 
nslookup <ip-number>

to find it out.
Marten


pgsql-interfaces by date:

Previous
From: "Larry Hess"
Date:
Subject: DAO VB ODBC "read only problems
Next
From: "Jeff Young"
Date:
Subject: timestamp Format on Binary Cursor