Time difference between deleteRecord vs deleteMultiple
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2024 02:00 PM - edited 08-05-2024 07:47 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024 06:28 AM
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.