Re: Oracle 8 Perf. with ASP / ODBC

From: Zane Schott <zschott_at_home.com>
Date: Wed, 30 Jun 1999 03:32:03 GMT
Message-ID: <Tcge3.9033$8D2.1330@news.rdc1.il.home.com>

Make sure that connection pooling is turned on in the ODBC driver. Microsoft's ODBC for Oracle works a little faster than Oracle's ODBC.

A quicker alternative to ODBC is to use Oracle Objects for OLE (oo4o) for data access. It is easy to implement in IIS and ASP.

It is free with Oracle.

Good Luck!
Zane E

vpanzer_at_my-deja.com wrote in message <7lacqr$e4t$1_at_nnrp1.deja.com>...
>We run a webapplication using Win NT, ASP, Oracle 8 (connected with
>ODBC). If just one user submits a query, it's really fast. If a second
>User presses "Submit" at the same time as the first user, than it takes
>more than 20 Seconds until the results appear on the screen
>(simultanously at both PCs !). Imagine 30 Users pressing "Submit" at the
>same time...
>
>Because the difference is so extrem, I suppose we just forgot to set a
>special Flag somewhere -- so I hope somebody else found a solution for
>that problem.
>
>Thank you in advance for any help !
>
>Volker
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 22:32:03 CDT