GX-Entwicklung

GX-Bug #70120

Von Moritz Bunjes vor etwa 2 Jahren 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.

Zurück