Re: TQuery or TTable?

Article View: borland.public.cppbuilder.database.ado

Article #3231

Back to borland.public.cppbuilder.database.ado Previous Next

#3231

From: Jerry Irons
Date: Wed, 30 Oct 2002 12:11

35 lines
1713 bytes

Hi,

I don't use Diamon Access Component, but in my experience use
TADODataset connecting to Access,

-TADODataset
-cursor location, "Use Server"

opening a query with parameters (and not using select *) is much
faster than filtering a table.  

using command type Table Direct may or may not be faster than a query.
(or even feasible)

If the database is a single user, local database, it may not matter
too much.

-Jerry

On Wed, 30 Oct 2002 11:36:34 +0200, "George K."
<george@nospammers.org> wrote:

>Hi,
>
>I'm using Diamond Access Component to access
>Microsoft Access database. I have a database with
>30.000 records.
>
>In general is it most preferable to use a TTable with
>the records or TQuery with a Select * from MyData ?
>What is faster?
>
>George K.
>

Technical Details

Message-ID: <jqivrucunjfelb3tkbgiu4pm6kbdsbbjf0@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

References: <3dbfa820$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3a664946b3be3236
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-10-30 06:30:02 PST
From: Jerry Irons <JIrons@compuserve.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: TQuery or TTable?
Date: Wed, 30 Oct 2002 07:11:10 -0500
Message-ID: <jqivrucunjfelb3tkbgiu4pm6kbdsbbjf0@4ax.com>
References: <3dbfa820$1@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 1035979808 24.54.9.179 (30 Oct 2002 04:10:08 -0800)
Lines: 37
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message