Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-2745

Slow performance for some screen elements

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.3rc1
    • Fix Version/s: 1.8.3
    • Component/s: Frontend (F)
    • Labels:
      None

      Description

      Here is debug information for one screen in screen editing form:

      Time:0.001112 SQL: SELECT * FROM screens_items WHERE screenid=3
      Time:1.370191 LONG SQL: SELECT DISTINCT n.nodeid, n.name as node_name, h.hostid, h.host, min(r.permission) as permission, ug.userid FROM hosts h LEFT JOIN hosts_groups hg ON hg.hostid=h.hostid LEFT JOIN groups g ON g.groupid=hg.groupid LEFT JOIN rights r ON r.id=g.groupid LEFT JOIN users_groups ug ON ug.usrgrpid=r.groupid and ug.userid=1 LEFT JOIN nodes n ON (h.hostid/100000000000000)=n.nodeid WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) GROUP BY h.hostid,n.nodeid,n.name,h.host,ug.userid ORDER BY n.name,n.nodeid, h.host, permission, ug.userid
      Time:0.08552 LONG SQL: SELECT t.triggerid FROM triggers t WHERE ((t.triggerid BETWEEN 000000000000000 AND 099999999999999))
      Time:92.065856 LONG SQL: SELECT DISTINCT t.triggerid,t.priority,t.description,t.expression,h.host,t.type FROM triggers t, functions f, items i, hosts h WHERE (t.triggerid IN (10001,10002,112280,112281,112282,112283,112284,112285,112286,112287,13933,112288,112289,112291,112290,112292,112293,112294,112295...

      The screen contains "History of events" element.

      Please review other screen elements as well.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            alexei Alexei Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: