Article View: borland.public.cppbuilder.database.ado
Article #2718Re: Any way to prevent Access from ballooning?
From: Jerry Bloomfield (TeamB)
Date: Sun, 13 Apr 2003 03:13
Date: Sun, 13 Apr 2003 03:13
19 lines
1955 bytes
1955 bytes
On Tue, 01 Apr 2003 16:30:31 -0500 (EST), "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> wrote: >I'm already doing the import exactly like you describe, except that I have >been calling Update(). In my experience, every time you call Update() Access will delete the existing row and insert a new one. One other observation I have made is that Access does not re-use space from a deleted record until the MDB file is compacted... What happens if you leave your index in place and insert your rows without calling Update()? Jerry Bloomfield (TeamB) -- http://www.teamb.com JersWork@iwc.net Please do *NOT* send private e-mail without prior permission (my anti-spam filters will probably just delete it anyway <g>)
Technical Details
Message-ID:
<galh9vg2oc66i4iikdupchr5tmgoc2esup@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mailReferences:
<gunaalqrneguyvaxarg.hcd9490.pminews@207.105.83.65> <3e892319$1@newsgroups.borland.com> <gunaalqrneguyvaxarg.hcop2v0.pminews@207.105.83.65>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-12 20:20:35 PST From: "Jerry Bloomfield (TeamB)" <JersWork@iwc.net> Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: Any way to prevent Access from ballooning? Date: Sat, 12 Apr 2003 22:13:22 -0500 Organization: LSVFA - Latest Software Version Freaks Anonomous Reply-To: "Jerry Bloomfield (TeamB)" <JersWork@iwc.net> Message-ID: <galh9vg2oc66i4iikdupchr5tmgoc2esup@4ax.com> References: <gunaalqrneguyvaxarg.hcd9490.pminews@207.105.83.65> <3e892319$1@newsgroups.borland.com> <gunaalqrneguyvaxarg.hcop2v0.pminews@207.105.83.65> X-Newsreader: Forte Agent 1.92/32.572 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 64.7.25.176 X-Trace: newsgroups.borland.com 1050203592 64.7.25.176 (12 Apr 2003 20:13:12 -0700) Lines: 19 X-Authenticated-User: jerswork Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail