Re: Oracle Database performance on Windows 2003 with IIS 6

seungykim_at_hotmail.com (Seung Y. Kim) wrote in news:d75ccfe9.0409011621.75e23d8d_at_posting.google.com:

> Hi everyone.
>
> I am having a big performance issue with my ASP application with
> Oracle database.
>
> The application itself is a very database-generic one, so I can switch
> from Access to SQLServer to Oracle with ease.
>
> The web-application runs great with Access and SQLServer. But when it
> comes to Oracle, the performance really lags.
>
> The Oracle server is 8.1.7 located in other server, and the web-server
> is the Oracle client. In windows 2000, I never had any performance
> issue with Oracle (actually Oracle was the fastest of all three
> database)
>
> Now that I move the application to Windows 2003 with IIS 6 on, the
> performance really lags.
>
> I have tried using both ODBC and OLE DB Drivers (from Microsoft and
> Oracle), and none of them seem to make any improvements.
>
>
> Any ideas of what's going on?
>

You are paying the price of being database neutral? On the average, it all evens out. Received on Thu Sep 02 2004 - 03:06:28 CEST