Deleting and Recreating Access Tables

[BarryC]

I have a program that imports data, processes it and places the results

into final tables. My problem is that it is really slow. Each temp
processing table has almost 2 million records in it. I have identified
the deletion of these temporary records as a bottleneck in the speed.

My first thought is to drop the tables and recreate them instead of
deleting the records.


Any thoughts on this? Better ideas? I've seen comments that this isn't
good for DB
stability.

 

[Marshall Barton]

I have a program that imports data, processes it and places the results

into final tables. My problem is that it is really slow. Each temp
processing table has almost 2 million records in it. I have identified
the deletion of these temporary records as a bottleneck in the speed.

My first thought is to drop the tables and recreate them instead of
deleting the records.

Temporary tables are best managed when they are in a
temporary database. Instead of deleteing the data or the
table, you can just delete the file. For some ideas, take
a look at: http://www.granite.ab.ca/access/temptables.htm