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
Paul,
- Original Message -
From: Paul Mallach [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 4:26 PM
Subject: innodb: TRUNCATE vs. DELETE FROM
Hi!
Is TRUNCATE optimized for innodb tables in MySQL 4.1.7?
http://dev.mysql.com/doc/mysql/en