Article View: borland.public.cppbuilder.database.ado
Article #2761Re: Any way to prevent Access from ballooning?
From: Mike Ruskai
Date: Tue, 01 Apr 2003 21:30
Date: Tue, 01 Apr 2003 21:30
22 lines
1933 bytes
1933 bytes
On Mon, 31 Mar 2003 18:33:35 +0400, Viatcheslav V. Vassiliev wrote: >You may try use ADO Recordset object without TCustomADODataSet wrapper. Get >it with Recordset property of TADODataSet, TADOQuery, TADOTable etc. Use >AddNew method and pass field names and values as parameters to this method, >do not call Update method. Use server-side cursor. > >Note that if database initially (before inserts) has empty space (for >example, some thousand rows was deleted before) this space will not be >reused. I'm already doing the import exactly like you describe, except that I have been calling Update(). Starting with a 100MB file (320,000 records) that was just compacted, an import of about 93,000 records results in a 500MB+ file. -- - Mike Remove 'spambegone.net' and reverse to send e-mail.
Technical Details
Message-ID:
<gunaalqrneguyvaxarg.hcop2v0.pminews@207.105.83.65>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!diablo.theplanet.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<gunaalqrneguyvaxarg.hcd9490.pminews@207.105.83.65> <3e892319$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,2e489a5b415e0003 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-04-01 13:39:33 PST Newsgroups: borland.public.cppbuilder.database.ado From: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> Message-ID: <gunaalqrneguyvaxarg.hcop2v0.pminews@207.105.83.65> References: <gunaalqrneguyvaxarg.hcd9490.pminews@207.105.83.65> <3e892319$1@newsgroups.borland.com> Date: Tue, 01 Apr 2003 16:30:31 -0500 (EST) Reply-To: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> X-Newsreader: PMINews 2.00.1205 For OS/2 Organization: TLF MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Subject: Re: Any way to prevent Access from ballooning? NNTP-Posting-Host: 65.40.123.13 X-Trace: newsgroups.borland.com 1049232631 65.40.123.13 (1 Apr 2003 13:30:31 -0800) Lines: 24 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!diablo.theplanet.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail