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

redundant queries in screens

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.2, 1.9.0 (alpha)
    • 1.8, 1.9.0 (alpha)
    • Frontend (F)
    • None

      opening a small screen (3x2) results in redundant queries :

      Time:0.00037 SQL: SELECT * FROM screens_items WHERE screenid=3
      Time:0.000275 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=0 AND y=0
      Time:0.00025 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=1 AND y=0
      Time:0.000241 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=2 AND y=0
      Time:0.000237 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=0 AND y=1
      Time:0.000246 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=2 AND y=1
      Time:0.000287 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=0 AND y=0
      Time:0.00033 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=1 AND y=0
      Time:0.000328 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=2 AND y=0
      Time:0.000341 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=0 AND y=1
      Time:0.000918 SQL: SELECT * FROM screens_items WHERE screenid=3 AND x=2 AND y=1

      even if the first query can't return all the needed data in one go, there are at least 6 duplicated queries out of 10

            Unassigned Unassigned
            richlv richlv
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: