Re: ORACLE 6/7 ODBC Access

In article <1b92c2f7_at_f573.n115.z1.fidonet.org>, Michael.Stowe_at_f573.n115.z1.fidonet.org (Michael Stowe) writes:
> *** Quoting Ditommm_at_Aa.Wl.Com to All dated 02-22-94 ***
> > I am able to connect to ORACLE (VAX/VMS v.7) using SQL*Net for Windows
> > and NetManage Chameleon TCP/IP for Windows by way of ODBC, HOWEVER - it is
> > unbelievably slow! Is ODBC/ORACLE worthless?
>
> ODBC is plagued by performance problems, particularly when accessing robust
> database server engines. It is not completely worthless, as long as you make
> an effort not to stress the pipe... For example, construct your SQL so that
> the database does the work -before- it gets to ODBC. Microsoft reportedly
> plans performance gains for ODBC v2.0. (The performance issue is clearly not
> Oracle's.)

Do you mean ODBC or Access (or another application)? I've heard of unpleasant experiences with Access and a few other applications, but much of this is related to the app. more than ODBC. One of the biggest complaints I've heard involves an application converting

   Select a, b from foo where a < 1000

to

   Select * from foo

and then picking columns & handling the where-clause itself. This can be a performance nightmare for many systems. But it is the fault of the application, not ODBC.

Also, which driver(s) have you tried and what were you doing with them? Performance is definitely a quality-of-implementation issue for drivers. I'm expecting a pretty good driver from Oracle, and I don't even bother using the one from Microsoft.

> Michael Stowe
> Director of Technical Services
> Constellation Engineering
 

-- 
The above statements are not the opinions or policies of SPSS Inc.
The above statements may not be the opinions of Brent Lambert.
The first disclaimer is a policy of SPSS Inc.
Subsequent disclaimers are probably the opinion of Brent Lambert.