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

    • Sprint 13, Sprint 14, Sprint 15, Sprint 16
    • 0.5

      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.

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

              Created:
              Updated:
              Resolved: