RE: ODBC

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 23 Mar 2004 17:28:31 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D82EF@25exch1.vicorpower.vicr.com>

The problem is that it's another layer of software that you have to go through on the client side. I'm not exactly sure what happens inside the ODBC layer, but the developers here have recorded delays of from 1 to 60 seconds. Data mapping appears to be the issue, and the more columns there are the worse it gets. BTW: the same query run through SQL*Plus, Pro*C, or OCI is sub second in it's reply.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

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

From: thump604_at_comcast.net [mailto:thump604_at_comcast.net] Sent: Tuesday, March 23, 2004 4: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:01:10 CST