Continue in 2 seconds

Do you have any information relating to very large, multiterabyte data warehouses and ODBC performance vs. other access methods to retrieve large queries?

By
  • Chuck Kelley, Les Barbusinski
Published
  • May 02 2003, 1:00am EDT

Q:

Do you have any information relating to very large, multiterabyte data warehouses and ODBC performance vs. other access methods to retrieve large queries? I don't think it is particularly efficient, but I need facts, studies, etc. to validate the claim. We are using Oracle 8i on Alpha's running Tru64.

A:

Les Barbusinski's Answer: You may want to look at a white paper by Ken North Computing, LLC which benchmarks ODBC performance against the native APIs for Oracle 8i. His findings indicate that there are ODBC drivers on the market today that match or exceed the performance of native Oracle drivers. The white paper can be found at the following URL:
http://www.datadirect- technologies.com/products/odbc/docs/WP_ODBCvsOCI.PDF

He also provides a rather comprehensive list of ODBC drivers, their platforms and the vendors that provide them on his home page.

Chuck Kelley's Answer: Sorry. While I don't have any specific studies, from my experience, Oracle and ODBC performance is, at best, bad. You will always get better performance using SQL*NET as your network environment. However, this is not necessarily true with other database management systems and ODBC.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access