[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