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

Optimize query when selecting data from profiles table

    XMLWordPrintable

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 13, Sprint 14, Sprint 15, Sprint 16
    • Story Points:
      0.5

      Description

      Zabbix web interface performs not optimal query when selecting all data from profiles table.

      SELECT p. * 
      FROM profiles p 
      WHERE p.userid = ? 
      ORDER BY p.userid , p.profileid
      

      Suggested to select only specific columns of the table instead of all * if they are not needed.

        Attachments

          Activity

            People

            Assignee:
            gcalenko Gregory Chalenko
            Reporter:
            ingus.vilnis Ingus Vilnis
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: