[eluser]OverZealous[/eluser]
[quote author="ben_co" date="1250888097"]Executing all these queries seems really inefficient compared to a simple db->update() and I wonder if there is quicker/more efficient way to do that.[/quote]
DMZ does not provide support for bulk updates. It is primarily focused on making changes to single objects. However, you can still call the normal, built-in ActiveRecord functions.
If you want, this could be written as an extension, to prevent duplicating a lot of code. Something like this:
Code:
function bulk_update($object, $params) {
// $params would be an associative array of key/value pairs
return $object->db->update($object->table, $params);
}