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

[Peter Kuehn [wmdb]]

 > Indexes

me, pointing up to the topic:
which indexes need to remain/be rebuilt on "clear all cache" in 
4.1.x/4.2.x ?
did I miss something?

gRTz
pekue



Marcus Krause schrieb:
> Steffen Kamper schrieb am 02/05/2009 12:35 PM Uhr:
>> 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)
> 
> The reason why:
> 
> Indexes
> 
> AFAIK, truncate doesn't care about indexes, it removes all rows in an
> "atomic operation". A delete will rebuild indexes after each removed row.
> 
> 
> 
> Marcus.