Board index » delphi » access 2000 / ADO - SLOW - VERY SLOW - HELP

Moyses Perillo

Delphi Developer
Mon, 24 Mar 2003 03:00:00 GMT

access 2000 / ADO - SLOW - VERY SLOW - HELP

access 2000 / ADO - SLOW - VERY SLOW - HELP
I have a system in paradox.
Because of the problems of index/header corruption  I try to use
access 2000 using  ADO. It does not lose more index but this is
too slow.. This making impracticable the system. Anyone knows what
I can make to improve the performance.
Moyses
Thank you
 
Sue D. No

Delphi Developer
Mon, 24 Mar 2003 03:00:00 GMT

Re:access 2000 / ADO - SLOW - VERY SLOW - HELP


Who's ADO components are you using?  Are you connected via ODBC?
Quote
Moyses Perillo wrote:
> access 2000 / ADO - SLOW - VERY SLOW - HELP
> I have a system in paradox.
> Because of the problems of index/header corruption  I try to use
> access 2000 using  ADO. It does not lose more index but this is
> too slow.. This making impracticable the system. Anyone knows what
> I can make to improve the performance.
> Moyses
> Thank you

Brian Bushay Team

Delphi Developer
Mon, 24 Mar 2003 03:00:00 GMT

Re:access 2000 / ADO - SLOW - VERY SLOW - HELP


Quote
>access 2000 / ADO - SLOW - VERY SLOW - HELP
>I have a system in paradox.
>Because of the problems of index/header corruption  I try to use
>access 2000 using  ADO. It does not lose more index but this is
>too slow.. This making impracticable the system. Anyone knows what
>I can make to improve the performance.

You will need to provide some specifics of what you are doing that is slower
with Ado/Access than it was with Paradox tables if you expect help and you
should post that question in the delphi.database.Ado section
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com
Moyses Perill

Delphi Developer
Mon, 24 Mar 2003 03:00:00 GMT

Re:access 2000 / ADO - SLOW - VERY SLOW - HELP


I am useing ADOConnection then i choise (use connection string) , build
in provider -> Microsoft jet 4.0 OLE DB Provider
then i select de file file.mdb
Quote
"Sue D. Nom" wrote:
> Who's ADO components are you using?  Are you connected via ODBC?

> Moyses Perillo wrote:

> > access 2000 / ADO - SLOW - VERY SLOW - HELP
> > I have a system in paradox.
> > Because of the problems of index/header corruption  I try to use
> > access 2000 using  ADO. It does not lose more index but this is
> > too slow.. This making impracticable the system. Anyone knows what
> > I can make to improve the performance.
> > Moyses
> > Thank you

Pierre du Part

Delphi Developer
Tue, 25 Mar 2003 03:00:00 GMT

Re:access 2000 / ADO - SLOW - VERY SLOW - HELP


http://www.finalfiler.com/delphi/ADO/index.html

Quote
"Moyses Perillo" <peri...@gratis1.com.br> wrote in message

news:39DCE361.B2A3BF27@gratis1.com.br...
Quote
> access 2000 / ADO - SLOW - VERY SLOW - HELP
> I have a system in paradox.
> Because of the problems of index/header corruption  I try to use
> access 2000 using  ADO. It does not lose more index but this is
> too slow.. This making impracticable the system. Anyone knows what
> I can make to improve the performance.
> Moyses
> Thank you

Marc Deroove

Delphi Developer
Tue, 25 Mar 2003 03:00:00 GMT

Re:access 2000 / ADO - SLOW - VERY SLOW - HELP


Hello Moyses,

have a look at the following site, I found it very instructive:

http://www.finalfiler.com/delphi/ADO/index.html

Regards.

Quote
Moyses Perillo <peri...@gratis1.com.br> wrote in message

news:39DCE361.B2A3BF27@gratis1.com.br...
Quote
> access 2000 / ADO - SLOW - VERY SLOW - HELP
> I have a system in paradox.
> Because of the problems of index/header corruption  I try to use
> access 2000 using  ADO. It does not lose more index but this is
> too slow.. This making impracticable the system. Anyone knows what
> I can make to improve the performance.
> Moyses
> Thank you

Other Threads

1. access 2000 slow to connect

2. ADO Query REALLY SLOW over slow connection

3. JPEG + DELPHI = sloooow, slow slow slow

4. SQL 7.0 Getting Slower and Slower and SLower ??

5. Putting data to a Table is SLOW, SLOW and SLOW

6. canvas->pixel is slow slow slow...

7. Navigation through access gets slower and slower ...

8. Help on slow MS Access Access

9. ADO-Access : much Slower than BDE-Paradox?

10. Slow Data Syncronization from Interbase to ADO(Access)