InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Mysql - Speed Of Delete Queries ? |
|
Answer» 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. 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. |
|