RE: ODBC
- From: "Grant Allen" <Grant.Allen@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Mar 2004 09:10:17 +1100
You're problems will be more likely with Access. If you know what you're doing
in ODBC, esp with SQLPrepare+SQLExecute, SQLExtendedFetch, fetch array size
config, and { CALL ... } pass-throughs, you'll find you can get equivalent
performance to OCI or other interfaces.
Access on the other hand is brain dead, usually doing such smart things as
copying an entire table locally to perform various operations, etc.
Of course, YMMV.
Ciao
Fuzzy
:-)
----------------------------------------------
The contents of this post are my opinions only
If swallowed seek medical advice
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
> thump604@xxxxxxxxxxx
> Sent: Wednesday, 24 March 2004 08:18
> 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:
