Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion - Mailing list pgsql-general

From Rod Enke
Subject Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Date
Msg-id 3D2A32F7.1030802@enke.org
Whole thread Raw
In response to Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-general
Markus,

Have you run Windows Performance Monitor and watched the CF counters?
 They may help pinpoint your problem.  Do you have maintain database
connection selected in your datasources?

-
Rod


Markus Wollny wrote:

>Hi!
>
>No, hostname_lookup is set false - this db is in a backend plane, so
>there's no direct route to the outside internet anyway - hostname lookup
>wouldn't make any sense. Our problem seems to lurk somewhere else... But
>thank you for your answer!
>
>Regards,
>
>    Markus
>
>
>
>>-----Ursprüngliche Nachricht-----
>>Von: Fathi Ben Nasr [mailto:fathi.engineer@gnet.tn]
>>Gesendet: Dienstag, 8. Januar 2002 08:51
>>An: Markus Wollny; cfdev@oosha.com; pgsql-general@postgresql.org
>>Cc: pgsql-odbc@postgresql.org
>>Betreff: Re: [GENERAL] Performance of ODBC-Driver /w IIS5.0/ColdFusion
>>
>>
>>
>>
>>In postgresql.conf do you have "hostname_lookup=true" ?
>>If so you could have a dns problem (to be more accurate a reverse dns
>>problem) or no dns at all.
>>So try to disable hostname lookups.
>>From my experience, dns problems are hard to guess and are
>>the source of
>>the
>>biggest connection time problems.
>>
>>Hope this helps.
>>
>>Fathi Ben Nasr.
>>
>>Markus Wollny a écrit :
>>
>>
>>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>
>
>







pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: 7.2.2?
Next
From: Tom Lane
Date:
Subject: Re: WAL recycling, Linux 2.4.18