(mysql.info.gz) Delete speed

Info Catalog

(mysql.info.gz) Update speed

(mysql.info.gz) Query Speed

(mysql.info.gz) Tips

 
 7.2.16 Speed of `DELETE' Statements
 -----------------------------------
 
 The time to delete individual records is exactly proportional to the
 number of indexes. To delete records more quickly, you can increase the
 size of the key cache.   Server parameters.
 
 If you want to delete all rows in the table, use `TRUNCATE TABLE
 tbl_name' rather than `DELETE FROM TBL_NAME'.   `TRUNCATE'
 TRUNCATE.
 

Info Catalog

(mysql.info.gz) Update speed

(mysql.info.gz) Query Speed

(mysql.info.gz) Tips