I recently migrated network-linked tables to a SQL server, and select queries run much quicker now. however, delete/append queries take quite some time (20+ minutes to run a standard delete query to remove 6000+ records).
i've read that I may be able to increase the speed by creating a delete query via pass-through query, but I'm a little stuck on the correct logic.
I've tried creating a PTQ using, "delete * from [mytable];" but to no avail (however, when replacing delete with select, the query executes just fine).
this query executes via button press, so I'm wondering if I need to adjust some VBA logic as well.
additional info: i'm simply looking to clear out the entire contents from mytable, and re-populate it with an imported spreadsheet (the spreadsheet gets imported just fine into a temp table, and then an append query runs immediately after)
can someone please assist?
thanks!
i've read that I may be able to increase the speed by creating a delete query via pass-through query, but I'm a little stuck on the correct logic.
I've tried creating a PTQ using, "delete * from [mytable];" but to no avail (however, when replacing delete with select, the query executes just fine).
this query executes via button press, so I'm wondering if I need to adjust some VBA logic as well.
additional info: i'm simply looking to clear out the entire contents from mytable, and re-populate it with an imported spreadsheet (the spreadsheet gets imported just fine into a temp table, and then an append query runs immediately after)
can someone please assist?
thanks!