Skip site navigation (1) Skip section navigation (2)

Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion

From: Rod Enke <rod(at)enke(dot)org>
To: Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Date: 2002-07-09 00:48:55
Message-ID: 3D2A32F7.1030802@enke.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
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(dot)engineer(at)gnet(dot)tn]
>>Gesendet: Dienstag, 8. Januar 2002 08:51
>>An: Markus Wollny; cfdev(at)oosha(dot)com; pgsql-general(at)postgresql(dot)org
>>Cc: pgsql-odbc(at)postgresql(dot)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
>
>
>
>
>  
>







In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-07-09 07:05:52
Subject: Re: HELP!! #DEFINE NAMEDATALEN 128 in postgres_ext.h causes
Previous:From: Dave PageDate: 2002-07-08 15:54:10
Subject: Re: HELP!! #DEFINE NAMEDATALEN 128 in postgres_ext.h causes ODBC-ERROR(s) ??

pgsql-general by date

Next:From: Darren FergusonDate: 2002-07-09 01:03:08
Subject: Re: Speeding up subselect ?
Previous:From: Martijn van OosterhoutDate: 2002-07-09 00:34:22
Subject: Re: Speeding up subselect ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group