Re: Performance Problems with Oracle 7.3 and Microsoft ODBC

On Mon, 13 Jul 1998 08:34:39 -0700, Vijay Raghavacharian <vragha_at_ctp.com> wrote:

>Guys !!
>
>We are having severe performance issues. We are having a Oracle
>database on NT server and trying to access the database from NT clients
>using the Microsoft ODBC driver. Our applciation is not transaction
>intensive. But we do search the database. In trying to connect to the
>database and creating the objects based on the data retirved from the
>database, we find the response unacceptable. Basically we fire SQL
>scripts - one after the other - to retrieve the required data. We are in
>the process of optimizing the SQL scripts - but I don't know how much
>juice we can get out of that - since most of the queries are very
>striahtforward and simple - maybe a couple of table joins. Are there any
>other paramters I need to look into.
>
>Thanks.

I've developed an ASP-application on MS-IIS. The database used ist MS-Access.
Now my boss wants this to be replaced by an oracle-db. So i'd to learn administering Oracle 8.0.4. (oh god, enterprise manger ....)
I imported the ms-access-db within oracle and tryed to let my application work with the oracle-db instead of ms-access. Now the point comes to the ODBC-driver. There are a few of possibilites:
* Use the ODBC-driver from Oracle (Version 8.0.4.4 from download-site NOT from 8.0.4 enterpsise edition this one doesnt's work with ADO) * use the ODBC-driver from Microsoft (from MDAC) * use a third-party ODBC-driver
I'd a look at MSDN and found Visigenic often talked about. Becouse of a former project i knew openlink and intersolve beeing ODBC-driver distributors.
Now for the Test:
My Test consists of the following:
* ASP-Script, that makes an SQL-Select with 2000 rows and puts them on a webpage.
* using different ODBC-connections
I stopped the time it took when I pressed the refresh-button the 2'nd time in the webbrowser (to allow resource-pooling) till having all the HTML-output visible in my webbrowser.
Here's for the result:

My old Ms-Access-Solution: 13 seconds

'Oracle ODBC Driver':                16 seconds
'Microsoft ODBC for ORACLE '    32 seconds
'Intersolve ODBC-Driver':              13 seconds

the Problem is, that Intersolve's solution costs 9750 DM for a webserver with single-CPU. (190DM for Clients). That's why i can't use that. Received on Fri Jul 24 1998 - 07:30:22 CDT