Bug #22074
Enhance UPDATE statements with native driver (MySQL)
| Status: | Closed | Start date: | 2010-02-07 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assignee: | Xavier Perseguers | % Done: | 0% |
|
| Category: | dbal | |||
| Target version: | - | |||
| TYPO3 Version: | Complexity: | |||
| PHP Version: | ||||
| Votes: | 0 |
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)
History
Updated by Xavier Perseguers over 3 years ago
Does not seem to make lots of sense after all.