(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
automatically generated byinfo2html