[TYPO3-dev] How standard compliant is "truncate"?

Peter Kuehn [wmdb] peter.kuehn at wmdb.de
Thu Feb 5 12:42:28 CET 2009


 >> Is truncate really faster?
it is - and has to be: delete without a where simply deletes every 
single row - by row, by row, by... ;)

Steffen Kamper schrieb:
> Hi,
> 
> Martin Kutschker schrieb:
>>
>> Is truncate really faster?  I assumed that a DELETE without a WHERE
>> clause will work internally the same as a TRUNCATE.
>>
> 
> for sure. We had some clients where clear cache lead to server crash. 
> Truncate does the job in less a minute there. (MySQL)
> 
> vg Steffen




More information about the TYPO3-dev mailing list