Actions
Bug #2850
openreports deletetion sql is not optimal
Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Description
I've just seen the following in the logs while deleting a host:
Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 628914 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 628914 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 628925 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 628925 Log Load (0.6ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 628936 SQL (0.3ms) DELETE FROM `reports` WHERE `reports`.`id` = 628936 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 628947 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 628947 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 628961 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 628961 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 628971 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 628971 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 628981 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 628981 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 628991 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 628991 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629002 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 629002 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629012 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629012 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629022 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629022 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629032 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629032 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629042 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629042 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629052 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629052 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629062 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 629062 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629073 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 629073 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629083 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 629083 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629093 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629093 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629103 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 629103 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629113 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629113 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629123 SQL (0.5ms) DELETE FROM `reports` WHERE `reports`.`id` = 629123 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629133 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 629133 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629143 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629143 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629153 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629153 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629163 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629163 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629173 SQL (2.4ms) DELETE FROM `reports` WHERE `reports`.`id` = 629173 Log Load (0.2ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629183 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629183 Log Load (0.5ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629193 SQL (0.2ms) DELETE FROM `reports` WHERE `reports`.`id` = 629193 Log Load (0.1ms) SELECT `logs`.* FROM `logs` WHERE `logs`.`report_id` = 629203 SQL (0.1ms) DELETE FROM `reports` WHERE `reports`.`id` = 629203
No data to display
Actions