By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,083 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,083 IT Pros & Developers. It's quick & easy.

Deleting lots of records and record size

P: n/a
I'm working on an application that imports and exports tons of CSV data,
like 64,000 records per file, and six or seven files in a set.

First off, by the tine I import a few hundred thousand records the database
is _huge_. Like 500 meg, although the csv files are only 25 meg in total.
When I compact the database its still 100meg. How do I keep the size down?

Second, I did a manual delete of 300,000 records yesterday by doing a
select-all in the table and then delete. Is there a faster way? Granted my
computer is no speed demon, but it must have taken twenty minutes or more.

Third, during that twenty minutes, Access was displaying that lovely little
"not responding" message in the title bar. Any way to get rid of that
message?

Thanks,

Mike
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Mike Turco" <mi*******@yahoo-nospam4me.com> wrote:
Second, I did a manual delete of 300,000 records yesterday by doing a
select-all in the table and then delete. Is there a faster way? Granted
my computer is no speed demon, but it must have taken twenty minutes or
more.


I think a delete query might speed up performance.

Regards,
Keith.
www.keithwilby.com
Nov 13 '05 #2

P: n/a

"Mike Turco" <mi*******@yahoo-nospam4me.com> wrote
First off, by the tine I import a few hundred thousand records the database is _huge_. Like 500 meg, although the csv files are only 25 meg in total.
When I compact the database its still 100meg. How do I keep the size down?

Are you importing to a new or existing table? If new, Access defaults the
field types to text usually, and the field size to 255. Import to an
existing table.

Write code using AddNew to import. This is *may* be quicker, and allows you
to put some DoEvents in the Loop, so that your db will not be "locked up"
Darryl Kerkeslager


Nov 13 '05 #3

P: n/a
On Tue, 11 Jan 2005 08:41:32 -0800, "Mike Turco"
<mi*******@yahoo-nospam4me.com> wrote:
I'm working on an application that imports and exports tons of CSV data,
like 64,000 records per file, and six or seven files in a set.

First off, by the tine I import a few hundred thousand records the database
is _huge_. Like 500 meg, although the csv files are only 25 meg in total.
When I compact the database its still 100meg. How do I keep the size down?

Second, I did a manual delete of 300,000 records yesterday by doing a
select-all in the table and then delete. Is there a faster way? Granted my
computer is no speed demon, but it must have taken twenty minutes or more.

Third, during that twenty minutes, Access was displaying that lovely little
"not responding" message in the title bar. Any way to get rid of that
message?

Thanks,

Mike

Deleting a lot of records which are indexed takes a long time
particularly on back ends. Depending on the database you are using you
can kill the table and replace with an empty copy, use delete object
whatever, or delete the indexes before deleting the records and then
recreate them. The latter may be needed if you can't kill the table
(eg if there are relationships).
David
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.