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

Christian Kuhn lolli at schwarzbu.ch
Thu Mar 25 00:49:54 CET 2010


Hey.

Christian Kuhn wrote:
> Type: Bugfix / Performance improvement
> 
> BT: http://bugs.typo3.org/view.php?id=13508
> 
> Branch: trunk
> 
> Problem:
> Thanks to #13504 we now have a dbal compatible way of truncating tables. 
> mysql handles this much more efficiently than delete from.
> 
> Solution:
> Use this new API method core wide where DELETE FROM with an empty WHERE 
> is called.

Attached v2 which uses the final method name exec_TRUNCATEquery(), I 
left out the changes in dbal and extbase, they must be picked up there 
again, for 4.4 only.

@Dmitry: Is your -1 still valid as the decision to implement the 
truncate method with #13504 is taken?

Regards
Christian
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 13508_02.diff
Type: text/x-patch
Size: 4586 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100325/1693304e/attachment.bin>


More information about the TYPO3-team-core mailing list