Re: [Phpmyadmin-devel] TRUNCATE instead of DELETE

Alexander, good idea. However is it possible to check for locks: "Not transaction-safe; you will get an error if you have an active transaction or an active table lock. " Rabus a écrit :

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

_______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

-- Marc Delisle