Re: ADO performance

From: Guillermo Ortega A. (gortega_at_dcf.pemex.com)
Date: 07/02/04


Date: Fri, 2 Jul 2004 11:35:53 -0500

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
>
>