RE: ODBC

From: Grant Allen <Grant.Allen_at_towersoft.com.au>
Date: Wed, 24 Mar 2004 09:10:17 +1100
Message-ID: <DCFC52557FAC7640A8782B13032B81B0034CAE@bishopsfinger.towersoft.canberra>

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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> thump604_at_comcast.net
> Sent: Wednesday, 24 March 2004 08:18
> 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:23:32 CST