RE: ODBC
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Mar 2004 17:28:31 -0500
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@xxxxxxxxxxx [mailto:thump604@xxxxxxxxxxx]
Sent: Tuesday, March 23, 2004 4:18 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
