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

Optimize query when selecting data from profiles table

    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: