-
Incident report
-
Resolution: Fixed
-
Trivial
-
None
with profile setting to show 200 rows per page (and debug enabled), item configuration page that shows 200 items out of 209 results in :
106 queries ----> "SELECT MAX(g.gui_access) as gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=3 AND g.usrgrpid=ug.usrgrpid"
106 queries ----> "SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=3 AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1"
together with api debug the page ends up being more than 4.5 mb large (and, of course, there's the db load increase)
also, this page does a large amount of queries against the items table, requesting info for single item at a time -
there are 192 queries of "SELECT i.itemid, h.* FROM hosts h, items i WHERE i.hostid=h.hostid AND (i.itemid IN"