Any way to prevent Access from ballooning?

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

Article #2739

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

#2739

From: Mike Ruskai
Date: Wed, 26 Mar 2003 17:12

12 lines
1550 bytes

If I insert somewhere around 100,000 records into a 100MB Access database
with about 320,000 records, the database balloons to over 500MB.

After compacting, it's back down to around 130MB. 

Is there anything one can do to prevent the file from growing so much?


--
 - Mike

Remove 'spambegone.net' and reverse to send e-mail.

Technical Details

Message-ID: <gunaalqrneguyvaxarg.hcd9490.pminews@207.105.83.65>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!out.nntp.be!propagator2-sterling!news-in.nuthinbutnews.com!cyclone.bc.net!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2e489a5b415e0003,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-26 09:30:21 PST
Newsgroups: borland.public.cppbuilder.database.ado
From: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net>
Message-ID: <gunaalqrneguyvaxarg.hcd9490.pminews@207.105.83.65>
Date: Wed, 26 Mar 2003 12:12:09 -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: Any way to prevent Access from ballooning?
NNTP-Posting-Host: 65.41.83.12
X-Trace: newsgroups.borland.com 1048698727 65.41.83.12 (26 Mar 2003 09:12:07 -0800)
Lines: 14
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!out.nntp.be!propagator2-sterling!news-in.nuthinbutnews.com!cyclone.bc.net!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail