Re: ODBC Perfomance !!!

In article <rdm6os03t8728rdo3ahvj2toc6mp0e1tss_at_4ax.com>,   npi_at_inet.net wrote:
>
> Hi,
>
> Any white paper or web page about ODBC perfomance or
> ODBC benchmarking ?
>
> I need info about the topics:
>
> ODBC vs. OO4O
> ODBC vs. OLE DB
>
> What is the best 'interface' to connect a Oracle database with a
> Visual Basic 5 application?

To the best of my knowledge, there are no whitepapers on the speed of the various interfaces. Assuming equally good implementations, OO4O should probably be the fastest, simply because it's an Oracle protocol designed with an Oracle database in mind. ODBC and OLE DB are Microsoft protocols written with SQLServer in mind.

The ODBC driver is significantly more mature than either the OLE DB or OO4O drivers, however, so there may be occasions in which we implement something more efficiently than OLE DB or OO4O.

For the majority of applications, however, performance should be roughly equal no matter which interface you choose.

Justin Cave
ODBC Development

The opinions above are mine alone, not those of Oracle

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 31 2000 - 00:00:00 CDT