GX-Entwicklung

The SQL query

UPDATE `address_book` ab LEFT JOIN `zones` z ON z.`zone_name` = ab.`entry_state` SET ab.`entry_zone_id` = z.`zone_id` WHERE ab.`entry_zone_id` = 0 AND z.`zone_id` IS NOT NULL;

is too slow, because of a missing INDEX of zones.zone_name.

ALTER TABLE `zones` ADD INDEX `zone_name` (`zone_name`);

10000 customer addresses need for example 55 seconds for the update on a local server.