[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