[TYPO3-dev] Speeding up Typo3

[Steffen Kamper]

"Ries van Twisk" <typo3 at rvt.dds.nl> schrieb im Newsbeitrag 
news:mailman.134124.1176208845.21067.typo3-dev at lists.netfielders.de...
>
> 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
>
>
Hey Ries,

can be solved by
DELETE FROM ...
ALTER TABLE `tablename` AUTOINCREMENT=1

I don't know how this works with other DB-Engines

vg  Steffen