[TYPO3-dev] Speeding up Typo3

Andreas Otto andreas.otto at dkd.de
Tue Apr 10 13:30:30 CEST 2007


Hi Dmitry,

Dmitry Dulepov wrote:
>> - Replace DELETE FROM with faster TRUNCATE TABLE:
>> http://bugs.typo3.org/view.php?id=5370
> 
> Truncate has the same speed as delete on Innodb.

One thing which is IIRC different between DELETE and TRUNCATE is that
TRUNCATE will reset the counter for fields using autoincrement.


Cheers,
Andreas 





More information about the TYPO3-dev mailing list