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

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

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>,<pgsql-odbc(at)postgresql(dot)org>
Cc: <cfdev(at)oosha(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Date: 2002-07-08 08:50:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-odbc
Le Vendredi 5 Juillet 2002 19:20, Markus Wollny a écrit :
> We've still not been successful in our attempts to migrate from oracle
> to PostgreSQL - and we've got ODBC under suspicion to cause a servere
> bottleneck.

IMHO, this is not an ODBC problem.
1) Did you allow enough shared memory to PostgreSQL?
2) If a page takes 50 seconds to load, this is most likely a problem of 
long-running queries. For example, if a views containing an ORDER BY 
statement is used in an INNER or LEFT JOIN, PostgreSQL is likely to take 
seconds to perform the join. So, turn debugging on and try to locate 
long-running queries.

Maybe you should post your questions on pgsql-general(at)postgresql(dot)org where you 
are more likely to meet Oracle users.

Jean-Michel POURE

In response to

pgsql-odbc by date

Next:From: Markus WollnyDate: 2002-07-08 09:02:35
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Previous:From: Fathi Ben NasrDate: 2002-07-08 05:50:56
Subject: Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion

pgsql-general by date

Next:From: Christoph DalitzDate: 2002-07-08 08:51:27
Subject: pgaccess problems
Previous:From: tonyDate: 2002-07-08 07:58:26
Subject: Re: database backup

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