Actions
Bug #7448
openhost deletion generates inefficient sql queries
Status:
New
Priority:
Normal
Assignee:
-
Category:
Performance
Target version:
-
Description
for example, deleting facts:
(0.1ms) BEGIN Model Load (5.9ms) SELECT `models`.* FROM `models` WHERE `models`.`id` = 2 ORDER BY models.name LIMIT 1 SQL (15.0ms) UPDATE `models` SET `hosts_count` = COALESCE(`hosts_count`, 0) - 1 WHERE `models`.`id` = 2 ORDER BY models.name FactValue Load (11.7ms) SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 2009 SQL (29.6ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995779 SQL (3.9ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995780 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995781 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995782 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995783 SQL (0.3ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995784 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995785 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995786 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995787 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995788 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995789 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995790 SQL (0.2ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995791 SQL (0.1ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995792 SQL (0.1ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995793 SQL (0.1ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995794 SQL (0.1ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995795 SQL (0.1ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995796 SQL (0.1ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` = 42995797 SQL (0.1ms) DELETE FROM `fact_values` WHERE `fact_. ...
Actions