Project

General

Profile

Actions

Bug #2850

open

reports deletetion sql is not optimal

Added by Ohad Levy almost 11 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

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

Also available in: Atom PDF