Recommended deletion method for 1Million software-installation records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
Hi Community,
We need to delete approximately 1 million filtered records from cmdb_sam_sw_install while leaving sys_object_source unchanged.
A prior cleanup used a recurring Scheduled Script Execution with setWorkflow(false) and record-by-record deleteRecord() in 10K batches. Each batch took approximately 35–37 minutes. We are also considering a Data Management Delete Job, Table Cleaner, or controlled deleteMultiple().
A recent Delete Job for 82K records on another table took two days, so we are concerned that one 800K execution may run continuously for several weeks.
For a one-time filtered cleanup, which method is safest and fastest while still supporting batching, restartability, and progress validation?