Discussion board
MySQL - Speed of DELETE Queries ?
By Manju S Reddy
MySQL - Speed of DELETE Queries????
Reply
Post   Reset
Teacher SiliconIndia replied to Manju S Reddy Friday, March 19, 2010
Hi Manjunath,
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.