Re: ADO performance

From: Arnie Mauer (someone_at_microsoft.com)
Date: 07/03/04 

Date: Sat, 3 Jul 2004 09:58:10 -0400

I strongly suggest that you install the Oracle administrative client and use
the Oracle OLEDB provider. This is especially true if you're using Oracle
8i or higher.

- Arnie

"Guillermo Ortega A." <gortega@dcf.pemex.com> wrote in message
news:40e58d06@newsgroups.borland.com...
> Microsoft OLE DB Provider for Oracle version according with registry MDAC
> 2.71.9030.4
>
> Thanks,
>
> Guillermo
>
>
> "Arnie Mauer" <someone@microsoft.com> wrote in message
> news:40e57132$1@newsgroups.borland.com...
> > "Guillermo Ortega A." <gortega@dcf.pemex.com> wrote in message
> > news:40e47ad1$1@newsgroups.borland.com...
> > >
> > > > Try setting BlockReadSize to 100 and CursorLocation to clUseServer.
> > > >
> > > > - Arnie
> > >
> > > No luck, the same performance.
> > >
> > > Guillermo
> > >
> > What OLEDB driver are you using for ADO?
> >
> > We also noticed 'poor' performance when switching from the BDE to ADO.
It
> > took some learning and tweaking the properties of the TADOQuery, but
> > eventually, performance was better than BDE/SQL Links.
> >
> > - Arnie
> >
> >
>
>

Relevant Pages

  • Re: Linked Server to Oracle 10g and INSERT performance
    ... i found out that it is much faster with the current oracle oledb provider ... using the Microsoft ODBC Driver for Oracle works without issues but is also slow! ... I have not tested the Oracle ODBC Driver using MSDASQL yet, ...
    (microsoft.public.sqlserver.connect)
  • Re: Excel, Microsoft Jet and OLE-DB
    ... Use the Oracle OLEDB provider. ... (remove nothere from the email address if mailing direct) ... It works fine with an ODBC connection but with very poor ...
    (microsoft.public.excel.programming)
  • Re: ASP interacting with Oracle server problem
    ... dynamically generate huge Oracle queries & those site's interactions with the ... > but that was months ago), only the unix database server. ... > the Oracle OLEDB provider that I could provide the developers? ... >> It sounds like a problem with the Oracle client software. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Oracle and VB - How Do I....
    ... > I can make a test connection to it with the Oracle OBDC Test tool so I ... Communicating with an Oracle database is not essentially different than ... ]You may want to consider using ADO and the Oracle OLEDB provider. ...
    (microsoft.public.vb.database)
  • Re: Data provider for Oracle and SQL 2005 on 64bit windows.
    ... If you do download the 64 bit oracle oledb provider that is provided as ... Microsoft refuses to put out an msdaora driver for x64 so we ... around ever since they released x64 drivers. ...
    (microsoft.public.sqlserver.connect)