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

Hello!

Probably not a problem of ODBC itself but more likely due to the change
in architecture in combination with the behaviour of the ColdFusion
server. With Oracle and it's schema-support (I'm looking very much
forward to seeing this feature in PostgreSQL later this year, hopefully)
it was easy for CF to assign the connections, because there only was one
datasource. Now we've got ten datasources altogether which could, I
presume, lead to the effect, that several transactions are carried out
for one datasource, but several others are still on queue for other
datasources, preventing the completion of the current website and
therefore just loading up ColdFusions request-queue in a vicious circle.

We're doing as much as possible to avoid long queries and have been
quite successful after a difficult start - Oracle's optimizer is quite a
bit more good natured and we've been a bit spoiled by it, I think. We've
eliminated all the "killer queries" and now we've got execution times of
just over 2 seconds for some rare big queries, most of the lot is well
below half a second.

We're still trying to find out what the bootleneck is, so thanks for
your hints!

Regards,

Markus

> -----Ursprüngliche Nachricht-----
> Von: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Gesendet: Montag, 8. Juli 2002 10:50
> An: Markus Wollny; pgsql-odbc(at)postgresql(dot)org
> Cc: cfdev(at)oosha(dot)com; pgsql-general(at)postgresql(dot)org
> Betreff: Re: [GENERAL] Performance of ODBC-Driver /w IIS5.0/ColdFusion
>
>
> 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
>