Hi! Is TRUNCATE optimized for innodb tables in MySQL 4.1.7?
http://dev.mysql.com/doc/mysql/en/TRUNCATE.html says: "For InnoDB, TRUNCATE TABLE is mapped to DELETE, so there is no difference.". But http://dev.mysql.com/doc/mysql/en/InnoDB_tuning.html claims: "Beware also of other big disk-bound operations. Use DROP TABLE or TRUNCATE TABLE (from MySQL 4.0 up) to empty a table, not DELETE FROM tbl_name." bye, Paul. -- Paul Mallach ARIVA.DE AG Ostseekai 2 D - 24103 Kiel Tel: +49 (0)431/97108-24 E-Mail: [EMAIL PROTECTED] Fax: +49 (0)431/97108-29 Internet: http://www.ariva.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
