| 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: | 200207081050.16055.jm.poure@freesurf.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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.
Cheers,
Jean-Michel POURE
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Dalitz | 2002-07-08 08:51:27 | pgaccess problems |
| Previous Message | tony | 2002-07-08 07:58:26 | Re: database backup |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Wollny | 2002-07-08 09:02:35 | Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion |
| Previous Message | Fathi Ben Nasr | 2002-07-08 05:50:56 | Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion |