[TYPO3-dev] Should t3lib_db support MySQL's REPLACE INTO statement?
Martin Kutschker
masi-no at spam-typo3.org
Thu Nov 13 17:40:43 CET 2008
Karsten Dambekalns schrieb:
> Hi.
>
> Ingo Renner wrote:
>> would you be interested to see a
>> $GLOBALS['TYPO3_DB']->exec_REPLACEquery() method?
>>
>> please refer to the MySQL docs [1] for details on replace...
>
> No.
>
> Apart from the portability issues it is slower than checking explicitly
> in most cases. Refer to various MySQL speed tuning talks found on the
> net. And it has issues with forein key referential integrity (if someone
> uses that), as it does a DELETE/INSERT, not an UPDATE. Thus (even for a
> moment) referential integrity is broken, the command fails.
I think it there are also issues or at least things you should be aware
of if you have multiple unique indices on the table. I think there
enough ways now to screw up TYPO3, no need to add another one ;-)
Masi
More information about the TYPO3-dev
mailing list