external list delete...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christian Lerche - 30 Jun 2003 16:59 GMT

Hello,

my problem is:
I have a list with 8000 rows (CSV)
I use this list to delete a row in a sql-database
that stores 2.000.000 rows..
(with command >> DELETE FROM XXX WHERE ID = 0000)

this way is very slow (a few second every 100 rows)
so my question: Is there another faster way to delete
rows ??

thanks

Reply to this Message

Val Mazur - 30 Jun 2003 17:57 GMT

Hi,

First of all check if you have index built on ID field. If you do not have
index, then the whole process will be slow, because database engine will
scan rows to find matching one. Also you could optimize it using IN clause
to delete batch of records in one shot

DELETE FROM XXX WHERE ID IN ( 0, 1, 2,3, 4...)

--
Val Mazur
Microsoft MVP

> Hello,
>
[quoted text clipped - 9 lines]
>
> thanks

Reply to this Message

VB Forum / Database Access / June 2003

external list delete...