Can you show us your code?
If you are using asp I would definitely recommend one of ADO/OraOLEDB or
oo4o
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Marty" <mphee_at_jump-technologies.com> wrote in message
news:5ff7c081.0201100955.6ded9232_at_posting.google.com...
> Have a lot of performance problems with IIS and Oracle.
>
> Setup
> w2k sp2
> Oracle 8.1.7
> Webserver load is usually less than 5%
>
> I wrote a test ASP page to connect to the database, and then run a
> query. The connection time was 1.515 seconds. The query time was
> 3.422 seconds. IIS is uning MSDAORA, and I created a VBS script to do
> the same thing. The results of the VBS script were the same.
>
> I then wrote a java app to run the exact same query. Connection time
> was around the same, but the query time was .170 seconds and .223
> seconds after two runs. The java app is using oracle oci8 JDBC.
>
> Any idea's?
>
> Thanks for the help,
>
> Marty
Received on Fri Jan 11 2002 - 04:58:38 CST
