Re: Slow Connection

<tt>Achmad Amin schrieb:</tt><blockquote type="CITE"><tt>Dear all,</tt><br /><tt>I develop application using Delphi and
Postgres(use</tt><br /><tt>Winzeos component to connect to postgres). But I have</tt><br /><tt>problem, when I run
applicationat first time, I wait</tt><br /><tt>about 1 minute to see the application. I think this</tt><br /><tt>happen
becausemy application to connect to postgres</tt><br /><tt>too slow. What I must do to reduce speed
connection</tt></blockquote><tt>                             ^^^^^^^^^^^^^ you mean increase?</tt><blockquote
type="CITE"><tt>betweenmy application to postgres ?</tt></blockquote><tt>Well, often this behavior can result from a
timedout</tt><br /><tt>name lookup (I assume you don't really have an official</tt><br /><tt>name for your client :-)
Tocheck this, try to 'telnet'</tt><br /><tt>to your server before you do anything else (so you will</tt><br /><tt>have
thesame situation). If this takes more than just</tt><br /><tt>one or two seconds - but succeeds after a while,
perhaps</tt><br/><tt>the one minute delay you mentioned - then it probably is</tt><br /><tt>the name lookup. In this
caseyou should add the IP address</tt><br /><tt>of your Win98 box and a name to either your '/etc/hosts' or</tt><br
/><tt>yournamed data base (probably in /var/named).</tt><p><tt>If telnet just works fast then try to do a select
statement</tt><br/><tt>using 'psql'. Does this one take the that long? Can you</tt><br /><tt>afterwards connect fast
fromyour Windoze-Box? Then</tt><br /><tt>it probably is the size of your database in relation to your</tt><br
/><tt>memory... 32MB is not much for a database server if you</tt><br /><tt>want to handle a huge amount of data. This
wouldbe accompanied</tt><br /><tt>by havy disk activity. Perhaps you can shut down your X</tt><br /><tt>environment -
ifyou have it running.</tt><p><tt>Hope this helps</tt><p><tt>Andreas</tt>