Article View: borland.public.cppbuilder.database.ado
Article #2770Re: Any way to prevent Access from ballooning?
From: Mike Ruskai
Date: Wed, 02 Apr 2003 23:58
Date: Wed, 02 Apr 2003 23:58
14 lines
1712 bytes
1712 bytes
On Wed, 2 Apr 2003 15:37:55 +0400, Viatcheslav V. Vassiliev wrote: >I found that if table has no indexes it can be filled without ballooning. If >table has index it seems that Access recalculate it every time new row is >inserted. Which begs the question, would it be practical to remove all indexes, do the bulk import, then recreate the indexes? -- - Mike Remove 'spambegone.net' and reverse to send e-mail.
Technical Details
Message-ID:
<gunaalqrneguyvaxarg.hcqqli0.pminews@207.105.83.65>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!out.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.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> <3e8acbae@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-02 16:04:02 PST Newsgroups: borland.public.cppbuilder.database.ado From: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> Message-ID: <gunaalqrneguyvaxarg.hcqqli0.pminews@207.105.83.65> References: <gunaalqrneguyvaxarg.hcd9490.pminews@207.105.83.65> <3e892319$1@newsgroups.borland.com> <gunaalqrneguyvaxarg.hcop2v0.pminews@207.105.83.65> <3e8acbae@newsgroups.borland.com> Date: Wed, 02 Apr 2003 18:58:30 -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.41.83.120 X-Trace: newsgroups.borland.com 1049327909 65.41.83.120 (2 Apr 2003 15:58:29 -0800) Lines: 16 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!out.nntp.be!propagator2-sterling!news-in-sterling.newsfeed.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail