Article View: borland.public.cppbuilder.database.ado
Article #735Re: Access 2K and ADO slow
From: Arnie
Date: Thu, 24 Mar 2005 20:02
Date: Thu, 24 Mar 2005 20:02
15 lines
1470 bytes
1470 bytes
"John Scott" <jscott@kw.igs.net> wrote in message news:4241e517$1@newsgroups.borland.com... > My appliction uses ADO with and Access 2K database. I mostly > use tables and indexes - to order the data. I find that seeks > and other database actions are slow. Are there any parameters > that I can modify that might speed it up? > > John A little more info would be helpful. If you're using TADOTable, don't. Use either the TADODataset or TADOQuery objects and use the SQL statement with a WHERE clause to filter your result and an ORDER BY to order it. - Arnie
Technical Details
Message-ID:
<42431ce8$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!proxad.net!gatel-ffm!gatel-ffm!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4241e517$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,1f7459b1c2069d5f X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Arnie" <none> Newsgroups: borland.public.cppbuilder.database.ado References: <4241e517$1@newsgroups.borland.com> Subject: Re: Access 2K and ADO slow Date: Thu, 24 Mar 2005 15:02:02 -0500 Lines: 17 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 24.151.53.204 Message-ID: <42431ce8$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1111694568 24.151.53.204 (24 Mar 2005 12:02:48 -0800) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!proxad.net!gatel-ffm!gatel-ffm!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail