Re: ADO performance
From: Guillermo Ortega A. (gortega_at_dcf.pemex.com)
Date: 07/02/04
- Next message: Mark Edington \(Borland\): "Re: a question about delphi 7.1 update (it's delphi 7 update bug?)"
- Previous message: Kevin Davidson: "ADO error "Invalid Cursor State" after updating Sybase Adaptive Server Anywhere to version 9.0.1.1862"
- In reply to: Arnie Mauer: "Re: ADO performance"
- Next in thread: Arnie Mauer: "Re: ADO performance"
- Reply: Arnie Mauer: "Re: ADO performance"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
>
>
- Next message: Mark Edington \(Borland\): "Re: a question about delphi 7.1 update (it's delphi 7 update bug?)"
- Previous message: Kevin Davidson: "ADO error "Invalid Cursor State" after updating Sybase Adaptive Server Anywhere to version 9.0.1.1862"
- In reply to: Arnie Mauer: "Re: ADO performance"
- Next in thread: Arnie Mauer: "Re: ADO performance"
- Reply: Arnie Mauer: "Re: ADO performance"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]