Re: Time to open TTable

Article View: borland.public.cppbuilder.database.multi-tier

Article #910

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#910

From: patrick martin
Date: Thu, 04 Jan 2001 16:34

25 lines
1905 bytes

There can be other benefits and hinderances of a re-tooling.

E.g. for the Access ODBC driver, I found TTable would often hang
completely getting the fields in a table.
TQuery could do this with a "select * from [Table1]" and was not
noticeably slower with no loss in functionality.

Howard Lee Harkness wrote:
> 
> Patrick Martin <patrickmmartin@freenet.co.uk> wrote:
> 
> >This may not be very welcome, but would this not be a good candidate for
> >a TQuery?
> >Opening it initially should be very quick.
> 
> All suggestions are welcome.  In this case, you got me to re-think my
> approach to the problem, and yes, a TQuery was *much* faster, by at
> least an order of magnitude.  (Actually, I made some other minor
> changes to the design, too)
> 
> Thank you.
> 
> Spam Me and Get Sued <harkness@suespammers.org>
> see www.suespammers.org for details & free spam-nuking email account

Technical Details

Message-ID: <3A54A62B.28F98F65@freenet.co.uk>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!212.74.64.35!colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!dnews!194.222.117.125

References:

<h2n65t43f0hk3svu8lp2v4j31nkk8bjjrs@4ax.com> <3A53B9CD.4D9FA179@freenet.co.uk> <mf395tcc6pjv22kom13vh70ms90ivnu7ti@4ax.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,18b1f3d2a3e79275
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-01-04 08:48:42 PST
Message-ID: <3A54A62B.28F98F65@freenet.co.uk>
Date: Thu, 04 Jan 2001 16:34:51 +0000
From: patrick martin <patrickmmartin@freenet.co.uk>
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Re: Time to open TTable
References: <h2n65t43f0hk3svu8lp2v4j31nkk8bjjrs@4ax.com> <3A53B9CD.4D9FA179@freenet.co.uk> <mf395tcc6pjv22kom13vh70ms90ivnu7ti@4ax.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 194.222.117.125
X-Trace: 4 Jan 2001 08:35:06 -0800, 194.222.117.125
Lines: 25
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!212.74.64.35!colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!dnews!194.222.117.125

Reply to Parent Message