Article View: borland.public.cppbuilder.database.ado
Article #3233Re: TADOTable and TADOQuery
From: Jerry Irons
Date: Wed, 30 Oct 2002 11:53
Date: Wed, 30 Oct 2002 11:53
22 lines
1470 bytes
1470 bytes
I suppose it depends on the database you are connecting to. In my experience, connecting to MS Access, opening and closing a query with parameters is much faster than filtering a table. Also I use TADODataset, "UseServer" cursor location. -Jerry On Sat, 26 Oct 2002 12:04:05 -0500, "Kim L. Utley" <kimutley@coserv.net> wrote: >Hello, > >Quick question. If I have a choice between using a TADOTable or TADOQuery >object when performing lookup's on existing records which is the fastest? > >Kindest Regards. > >Kim >
Technical Details
Message-ID:
<ishvrusvrl01rb0jit752sfjrma0c4tjm8@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.online.be!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailReferences:
<3dbac914@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,1f9c6ea8a3b848d2 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-10-30 08:12:03 PST From: Jerry Irons <JIrons@compuserve.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: TADOTable and TADOQuery Date: Wed, 30 Oct 2002 06:53:04 -0500 Message-ID: <ishvrusvrl01rb0jit752sfjrma0c4tjm8@4ax.com> References: <3dbac914@newsgroups.borland.com> X-Newsreader: Forte Agent 1.91/32.564 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.54.9.179 X-Trace: newsgroups.borland.com 1035978722 24.54.9.179 (30 Oct 2002 03:52:02 -0800) Lines: 23 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.online.be!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail