TQuery or TTable?

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

Article #3230

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

#3230

From: George K.
Date: Wed, 30 Oct 2002 09:36

11 lines
1243 bytes

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: <3dbfa820$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3a664946b3be3236,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-10-30 02:08:01 PST
From: "George K." <george@nospammers.org>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: TQuery or TTable?
Date: Wed, 30 Oct 2002 11:36:34 +0200
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.103.232.192
Message-ID: <3dbfa820$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1035970592 62.103.232.192 (30 Oct 2002 01:36:32 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail