Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ODBC

RE: ODBC

From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
Date: Tue, 23 Mar 2004 15:42:10 -0700
Message-ID: <87E9F113CEF1D211A4C3009027301874272DDD@ddbcinc.ddbc.local>


In what context is performance bad? And what are we comparing the performance to?

In general, there are two strikes (performance-wise) against ODBC and Oracle. First, ODBC is a "least common denominator" API, so it is designed to only support functionality that every database in the world supports. It tends to make it difficult or impossible to take advantage of many Oracle-specific features which may tend to improve performance. Second, ODBC was designed by Microsoft, so ODBC was designed to work the way SQL Server works. There are a number of components of the ODBC API that require Oracle to do extra work under the covers in order to simulate functionality that SQL Server has by default (Microsoft would have similar problems if Oracle wrote the API) and a couple of cases where I would wager that Microsoft specifically designed a feature to be as hard as possible for Oracle to implement.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of thump604_at_comcast.net Sent: Tuesday, March 23, 2004 2:18 PM
To: oracle-l_at_freelists.org
Subject: ODBC

Can someone please expand on why using ODBC to query an Oracle database is not good in terms of performance?

Mix is MS Access 97 and ODBC to Oracle 8174

Thanks
--

- David
Life is what happens while waiting
or planning for the future.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Mar 23 2004 - 18:21:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US