[TYPO3-core] RFC: Bug #13508: Use exec_TRUNCATETABLEquery() instead of DELETE FROM throughout the core

Martin Kutschker masi-no at spam-typo3.org
Thu Feb 11 11:39:33 CET 2010


Dmitry Dulepov schrieb:
> As a developer, I'd like to simply use exec_DELETEquery. Why should I
> care if TRUNCATE is faster?

But there is one significant difference. DELETE removes each row and will therefore fire row
triggers. TRUNCATE doesn't do that. So if you use triggers it's not only a matter of speed, it's a
trade-off between speed and integrity.

Masi


More information about the TYPO3-team-core mailing list