MySQL - Speed of DELETE Queries ?

If you want to delete all rows in the table, you should use TRUNCATE TABLE table_name.

The time to delete a record is exactly proportional to the number of indexes. To delete records more quickly, you can increase the size of the index cache.