10x performance increase on graphs permission check

XMLWordPrintable

    • Type: Patch request
    • Resolution: Duplicate
    • Priority: Trivial
    • None
    • Affects Version/s: 3.4.14
    • Component/s: API (A)
    • None

      In our environment SQL query execution time for graphs permission check is 40 - 50 seconds.

      After combine 'check permissions by Y min item' and 'check permissions by Y max item' with 'check permissions by graph items', the query execution time is 4 - 5 seconds.

      Trivial patch [^zabbix-graph-permissions.diff]

            Assignee:
            Unassigned
            Reporter:
            Eugeny Shkrigunov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: