Issue Bug Closed

#22074Enhance UPDATE statements with native driver (MySQL)

Xavier Perseguers 02/07/10, 12:34 updated 02/07/10, 14:52

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.