Time difference between deleteRecord vs deleteMultiple

Suggy
Giga Sage

I need to delete around 100k records.

 

I tested with deletion of 2000 records using both methods, I did not find much difference in the time it took using both methods (deleteRecord vs deleteMultiple) for deleting same data (hardly a difference of 10s)

 

But I read in other community posts that 'deleteMultiple' will be quicker.

 

Question - Is is like only for LARGER datasets only deleteMultiple will make a difference and not smaller datasets?

If yes, larger datasets means how large?

 

5 REPLIES 5

Bert_c1
Kilo Patron

what is Large is depends on the table. Deleting records from task or cmdb tables will take longer than tables outside of either hierarchy. anyway, use deleteMultiple() as suggested by others.