*Add indices in waypoint converter to greatly improve its speed. By sparc.

--HG--
branch : trunk

1 files changed, 10 insertions, 1 deletions

diff --git a/sql/updates/3257_world_waypoint_data_converter.sql b/sql/updates/3257_world_waypoint_data_converter.sql
index 3533f948747..4a620ad73f7 100644
--- a/sql/updates/3257_world_waypoint_data_converter.sql
+++ b/sql/updates/3257_world_waypoint_data_converter.sql
@@ -1,6 +1,15 @@
+ALTER TABLE creature_addon ADD INDEX ( `path_id` );
+ALTER TABLE waypoint_data ADD INDEX ( `id` );
+ 
 ALTER TABLE waypoint_data ADD COLUMN id_old int(10) unsigned NOT NULL default '0' COMMENT 'Creature GUID' AFTER wpguid;
+
 UPDATE waypoint_data SET id_old=id;
+ALTER TABLE waypoint_data ADD INDEX ( `id_old` );
+
 UPDATE waypoint_data,creature_addon SET waypoint_data.id=creature_addon.guid*10 WHERE creature_addon.path_id > 0 AND creature_addon.path_id=waypoint_data.id_old;
 UPDATE waypoint_data SET id = 1343801 WHERE id_old = 2084;
 UPDATE waypoint_scripts SET datalong = 1343801 WHERE id = 515;
-ALTER TABLE waypoint_data DROP COLUMN id_old;
\ No newline at end of file
+
+ALTER TABLE waypoint_data DROP COLUMN id_old;
+ALTER TABLE `creature_addon` DROP INDEX `path_id` ;
+ALTER TABLE waypoint_data DROP INDEX `id`;
\ No newline at end of file