Actions
Bug #22074
closed
Enhance UPDATE statements with native driver (MySQL)
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-02-07
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
UPDATE operations in exec_UPDATEquery and exec_INSERTquery of class.ux_t3lib_db.php could be enhanced for native driver (MySQL) as they currently loop over each field and perform multiple UPDATE operation, one for each field:
UPDATE table SET field1 = value1 WHERE condition
UPDATE table SET field2 = value2 WHERE condition
UPDATE table SET field3 = value3 WHERE condition
...
instead of performing a single query:
UPDATE table SET field1 = value1, field2 = value2, field3 = value3 WHERE condition
(issue imported from #M13452)
Updated by Xavier Perseguers almost 15 years ago
Does not seem to make lots of sense after all.
Actions