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.
