GNU Info

(mysql.info)Delete speed

---

Next: Tips Prev: Update speed Up: Query Speed

---

Enter node , (file) or (file)node

Speed of `DELETE' Queries
-------------------------

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

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. Note: Server parameters.