[TYPO3-dev] Speeding up Typo3

[Ries van Twisk]

On Apr 10, 2007, at 6:30 AM, Andreas Otto wrote:

> 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
>
And truncate is not found in the SQL standard...

Although supported by other DB vendors,
not all of them seem to reset the autoincrement/serial field for
whatever reason people want that.

Ries