One Large DELETE FROM WHERE NULL Or Multiple Small DELETE FROM WHERE NULLS for Better Performance?

Question

I have a ForEach Loop Container that enumerates a massive amount of Excel Files. All files have NULL rows mixed in with the populated Rows. These need deleted upon migration into database.

What performs better: one massive DELETE FROM foo or multiple small DELETE FROM foos within ForEach Loop Container?

Have a look at this answer [`How to delete large data of table in SQL without log?`](http://stackoverflow.com/questions/24213299/how-to-delete-large-data-of-table-in-sql-without-log) — M.Ali, Mar 07 '15 at 01:25

score 0 · Answer 1 · answered Mar 07 '15 at 00:37

0

Set row count to 5000 and delete until done. This is the best that I have noticed. I delete a lot of very old transactions daily before I used this method, I had a lot of issues.

answered Mar 07 '15 at 00:37

Bill Gauvey

95
1
5

score 0 · Answer 2 · answered Mar 11 '15 at 08:51

0

here I used conditional split and based on that I removed nulls and passed not null rows to destination

Is this what you have asked....

answered Mar 11 '15 at 08:51

koushik veldanda

1,079
10
23

One Large DELETE FROM WHERE NULL Or Multiple Small DELETE FROM WHERE NULLS for Better Performance?

2 Answers2