How to delete large number of records from core_company table.

Not applicable

We are trying to cleanup duplicates from our core_company table. In order to do that we have to delete a large number of records. i.e 11,000, 80,000 etc.

I've tried the following options but it takes a lot of time and all records are still not getting deleted:

1) Script: takes time and deletes only 20..30% of records.

2) Data Manager> Delete all with preview: Takes internity to complete i.e 3-4 hours, deletes 90% records.

3) Direct deletion from tables list view: quick but deletes only 100 records in one go.

 

Please suggest the best way to delete records from core_company table.

5 REPLIES 5

@HrishabhKumar 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.