[Phpmyadmin-devel] TRUNCATE instead of DELETE

Rabus rabus at bugfixes.info
Mon Apr 22 11:15:01 CEST 2002


Hello list,

If you let me, I'd modify the code to use TRUNCATE instead of DELETE when
emptying tables if MySQL 4 is used since this is a much faster way:
The DELETE command deletes the table content row by row while TRUNCATE drops
and recreates the table.
Some doc about this: http://www.mysql.com/doc/T/R/TRUNCATE.html

Alexander





More information about the Developers mailing list