Missing indexes in hosts table

[GoogleCodeExporter]

Hi,

There is slow query in wpkgExpress caused by query like :

SELECT `Host`.`id`, `Host`.`name`, `Host`.`enabled`, `MainProfile`.`id_text` 
FROM `hosts` AS `Host` LEFT JOIN `profiles` AS `MainProfile` ON 
(`Host`.`mainprofile_id` = `MainProfile`.`id`)  WHERE `Host`.`enabled` = 1   
ORDER BY `Host`.`position` asc;

Solution / Mitigation :

add index on enabled field in hosts table :

ALTER TABLE `hosts` ADD INDEX ( `enabled` )

Regards,

Original issue reported on code.google.com by yann.ric...@gmail.com on 1 Mar 2013 at 9:48