Zabbix 1.5.4 Build-5784 - Events :: Slow

[Palmertree]

Zabbix 1.5.4 Build-5784 - Events :: Slow

Viewing lots of triggerids and hostids was very slow up to 400 seconds. Found there was a NULL reference in the from clause to host_groups which was never used. Removing this table from the SQL query made events pop up within less than 2 seconds.

In events.php

diff -ruN zabbix-original/frontends/php/events.php zabbix/frontends/php/events.php
--- zabbix-original/frontends/php/events.php    2008-06-20 03:42:25.000000000 -0400
+++ zabbix/frontends/php/events.php     2008-06-23 15:52:44.000000000 -0400
@@ -259,7 +259,7 @@
                        $sql_cond = ' and h.hostid=hg.hostid and hg.groupid='.$_REQUEST['groupid'];
                }
                else{
-                       $sql_from = ', hosts_groups hg ';
+                       $sql_from = '';
                        $sql_cond = ' and h.hostid in ('.$available_hosts.') ';
                }

[Aly]

Thank You. Fixed.