[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