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

value mappings retrieved multiple times

XMLWordPrintable

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

      overview -> data, maybe other places. same value mapping is retrieved from the database multiple times, for example :

      Time:0.016482 LONG SQL: SELECT newvalue FROM mappings WHERE valuemapid=8 AND value='1'
      Time:0.000397 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='1'
      Time:0.000308 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='1'
      Time:0.000427 SQL: SELECT newvalue FROM mappings WHERE valuemapid=8 AND value='1'
      Time:0.000318 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='0'
      Time:0.000283 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='1'
      Time:0.000409 SQL: SELECT newvalue FROM mappings WHERE valuemapid=1 AND value='1'

      here 7 queries are executed, when 3 would have been enough (8-1, 1-1, 1-0)

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

              Created:
              Updated:
              Resolved: