[TYPO3-dev] Speeding up Typo3

[Steffen Kamper]

"Mathias Schreiber [TYPO3]" <mathias at typo3.org> schrieb im Newsbeitrag 
news:mailman.1.1176215058.6842.typo3-dev at lists.netfielders.de...
> 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?
>
yes, look here:
http://dev.mysql.com/doc/refman/5.0/en/truncate.html

vg  Steffen

> ;-)
>
> No, for real now... The only point I recall now would be clearing cache...