Re: Oracle ODBC performance SUCKS!@

Bubba,
As you say yourself, your tests were informal and not scientific, so you should not jump to conclusions, especially to the conclusion that one product or another is trash. The quality of ODBC drivers has varied greatly over the past two years, both among vendors and among versions released by the same vendor. Moreover, what worked well one month did not always work well the next. Assorted problems with ODBC drivers have taught me this lesson: avoid ODBC, if you can, when there's real work to be done. Since your customer already owns Oracle 8, take a look at Oracle Objects for OLE (aka OO4O).

I'm not using Oracle 8 yet -- but OO4O works very well with Oracle 7. Someone in the know please inform me if I've given Bubba a bum steer with respect to OO4O and Oracle 8.

Tim Romano
tim_at_superstream.net

>
> On Fri, 1 May 1998 18:32:42 -0400, "bubba" <brittonb_at_webt.com> wrote:
>
> >Two identical tables: one in MS SQL Server, the Other in Oracle 8 NT.
> >(NT Server 4.0 SP3, 96 MB RAM, PII 266, SCSI Wide 4-g. Stripped system of no
> >other extraneous applications, processes.)
> >
> >Access 97 linked tables via ODBC (BOth Microsoft ODBC drivers, one for
> >oracle, the other SQL Server.)
> >
> >Loading a page full of data from the Oracle 8 server causes my one-user load
> >NT server performance to sky rocket to 97% for three seconds just to pull
> >back a pagefull of data in MS Access via ODBC from the Oracle 8 Server.
> >
> >Using the same linked table(exact schema) but MSAccess to MS Sql Server
> >results in a page of data coming in less than 1 second and NT performance
> >monitor shows 2% utilization on the processor for this test.
> >
> >Now I know that this is informal and not scientific. But , Oracle Sucks!
> >
> >Every time I hit page down in MS access via ODBC to Oracle 8 it takes three
> >to four seconds per page of data. In MS Sql server it's pretty much
> >instantaneous.
> >
> >By the way, I ran each test on the server while only one database server
> >process was running(ie., Oracle 8 Alone on the server, then MS SQL Server
> >alone on the server.
> >
> >What the hell is going on?
> >
> >How can somebody reliably develop with ODBC and Oracle 8? With 1 user Oracle
> >8 is brought to it's knees!
> >
> >I have Oracle 8 running in the default configuration but with 30mb SGA.
> >
> >I absolutely have to know if I can tweak Oracle 8 into a usable system for a
> >VB5 to Oracle 8 application via ODBC. If not, I have to explain to my
> >customer to switch to MS SQL(they already own oracle 8).
> >
> >I can't imagine running a 100-user + system on Oracle 8. What's all the
> >hubbub about Oracle 8 anyway. Does it just suck on NT or what?
> >
> >brittonb_at_webt.com
> >
> >
>
> Thanks!
>
> Joel
>
> Joel R. Kallman
> Oracle Government, Education, & Health
> Columbus, OH http://govt.us.oracle.com
> jkallman@us.oracle.com http://www.oracle.com
>
> ----
> The statements and opinions expressed here are my own
> and do not necessarily represent those of Oracle Corporation.
Received on Sun May 03 1998 - 07:32:56 CDT