Widget "System Status" is slow on installations with huge amount of PROBLEM triggers and Host Groups

XMLWordPrintable

      ******************** Script profiler ********************
Total time: 39.737475
Total SQL time: 10.014377
SQL count: 5764 (selects: 5749 | executes: 15)
Peak memory usage: 461.25M
Memory limit: 1024M

      Amount of Host Groups: 2110
      Amount of PROBLEM triggers: 5709

      The issue is in selectLastEvent option. There is very slow place.

        1. groups.png
          groups.png
          11 kB

            Assignee:
            Ivo Kurzemnieks
            Reporter:
            Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: