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

[Dan Osipov]

Yes - and it locks the site, since new entries to the cache wait for the 
query to complete.

I have to manually truncate the table prior to running clear all cache 
(our pages_cache table grows to over 25 Gb)

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Peter Kuehn [wmdb] wrote:
>  >> 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