Peter Lauri wrote:
DELETE FROM table
Truncate will be a lot better.DELETE FROM table will do it row by row which also means it will have to update any indexes applicable to the table as it goes...
Lots of data & lots of indexes = very slow. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]