What is the fastest way to delete 1000000 records in cmdb (incl cascade deletes) ?

tommyjensen
Giga Expert

‎11-10-2015 05:23 AM

However some records should NOT be deleted?

Using a background script and deleting with deleteMultiple() runs 20 minutes to delete 100 records! It must be possible to do that faster even with cascade deletes.

0 Helpfuls
  • 17,032 Views
25 REPLIES 25

NToo
Tera Expert

2 weeks ago

I've found the fastest method is to use Delete Jobs (sys_dm_delete) under System Data management.

Seems to run at about 5-10 records per second on our subprod instance

0 Helpfuls