Re: Speed up Database

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

Article #4461

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

#4461

From: David Barnes
Date: Thu, 03 Jan 2002 15:19

7 lines
1349 bytes

Plz correct me if I am wrong, but when you append to a table, isn't the
table being refreashed after every append?! This would make it slower.

If you are posting this way, maybe set cachedUpdates to true first. This
will allow you to make all appends on your machine in memory(stored
client side) then when all post have been made, you can write all
transactions in a single post. I would think that might be abit faster.

Technical Details

Message-ID: <3C34767A.1060706@kalos-inc.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!hub1.nntpserver.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3c1eb21f_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,77d6545c02a2aaf5
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-01-03 07:23:10 PST
Message-ID: <3C34767A.1060706@kalos-inc.com>
Date: Thu, 03 Jan 2002 09:19:22 -0600
From: David Barnes <david@kalos-inc.com>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.4) Gecko/20011019 Netscape6/6.2
X-Accept-Language: en-us
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Speed up Database 
References: <3c1eb21f_1@dnews>
Content-Type: text/plain; charset=Big5
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 65.69.231.139
X-Trace: dnews 1010071163 65.69.231.139 (3 Jan 2002 07:19:23 -0800)
Lines: 8
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!hub1.nntpserver.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message