#22074Enhance UPDATE statements with native driver (MySQL)
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)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.