[TYPO3-core] RFC: Bug #13508: Use exec_TRUNCATETABLEquery() instead of DELETE FROM throughout the core
Dmitry Dulepov
dmitry.dulepov+t3ml at gmail.com
Thu Feb 11 13:03:08 CET 2010
Hi!
On 2010-02-11 12:47:23 +0200, Peter Niederlag said:
> If in some future we make use of triggers we will have a bad mess and
> also it might cause trouble for any people already using triggers.
Unused generaility is a bad design pattern :)
> As a developer I'd like my code to execute as I write it and not some
> magic trying to change it into something else.
Than you do not need API :)
By the way, using TRUNCATE instead of DELETE on cache tables makes
saving TS templates a single second job. In case if site is large,
deleting many thousands rows goes forever even if cache tables is
InnoDB. Truncating is lightning fast.
--
Dmitry Dulepov
TYPO3 expert / TYPO3 core team member / TYPO3 security team member
Read more @ http://dmitry-dulepov.com/
More information about the TYPO3-team-core
mailing list