Deleting and Recreating Access Tables

  • Thread starter Thread starter BarryC
  • Start date Start date
B

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? I've seen comments that this isn't good for DB
stability.
 
BarryC said:
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? I've seen comments that this isn't good for DB
stability.
Click to expand...


Please don't post the same question to multiple groups. See
http://www.mvps.org/access/netiquette.htm for suggestions on
how to use these groups effectively.

I tried to provide an idea for this situation in another
newsgroup.
 
Back
Top