[Phpmyadmin-devel] TRUNCATE instead of DELETE

[Marc Delisle]

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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

-- 
Marc Delisle