RE: ODBC

From: <oracle-l-bounce_at_freelists.org>
Date: Wed, 24 Mar 2004 10:03:19 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D82F0@25exch1.vicorpower.vicr.com>

Allen,

        I'd enlarge that statement. Most MicroSlop products are Brain Dead. The duhvelopers have recorded similar behavior with ASP as well.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Grant Allen [mailto:Grant.Allen_at_towersoft.com.au] Sent: Tuesday, March 23, 2004 5:10 PM
To: oracle-l_at_freelists.org
Subject: RE: ODBC

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
-----------------------------------------------------------------
----------------------------------------------------------------
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 Wed Mar 24 2004 - 08:59:49 CST