[TYPO3-dev] Speeding up Typo3

[Mathias Schreiber [TYPO3]]

Martin Kutschker schrieb:
> Steffen Kamper schrieb:
>>
>> Hey Ries,
>>
>> can be solved by
>> DELETE FROM ...
>> ALTER TABLE `tablename` AUTOINCREMENT=1
>>
>> I don't know how this works with other DB-Engines
> 
> No.
> 
> Anyway, how often are "DELETE FROM table" queries used to justify a 
> speed-up (for Mysiam tables) with "TRUNCATE table"?

to be honest, I just could not wait for the beta release where all 
DELETE FROM statements were exchanged by TRUNCATE.

If I recall correctly truncate clears the entire table regardless of 
WHERE clauses, doesn't it?

;-)

No, for real now... The only point I recall now would be clearing cache...