[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