[TYPO3-dev] Speeding up Typo3

Martin Kutschker Martin.Kutschker at n0spam-blackbox.net
Tue Apr 10 16:20:49 CEST 2007


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"?

Masi

PS: To get a portable solution we *could* add a 
t3lib_db->clearTable($table) function, but I don't see the need for it.




More information about the TYPO3-dev mailing list