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

How do I speed up an Access (SQL) Delete all records

P: 5
I have a csv file that I download from a remote server every morning at 8am.

This is imported in access and written to an Access table on one of the servers, having first deleted the previous days version of the Access table.

The importing of the csv and then the outputting to the Access table takes less than 5 minutes, but the deleting of the records in-between from the discarded table is taking upto 50 minutes.

The table is around 55,000 records (each with 14 fields).

I am working in Windows Server 2003 with MS Access 2003.

I am using a standard Access delete query, the SQL reads as :
Expand|Select|Wrap|Line Numbers
  1. DELETE dbo_tbl_Ben_INV_MID_INV_DET_BEN.*
  2. FROM dbo_tbl_Ben_INV_MID_INV_DET_BEN;
  3.  
Any ideas how I could speed this up as this seems very slow for that many records?
Nov 4 '08 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
Hello, kilabyte.
  • Does the table reside on MS SQL server ("dbo" prefix in table name)? If so, then would pass-through query work better?
  • Have you tried to drop the whole table instead of deleteing records?

Regards,
Fish
Nov 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.