[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