GX-Bug #70120
Von Moritz Bunjes vor mehr als 1 Jahr aktualisiert
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. server environment.