1.9.5 screen performance problems

[srknc]

hi,
i upgraded zabbix to 1.9.5 from 1.8.3.
For that, copied tables to another db and run db pathces (upgrades/dbpatches/2.0/mysql/patch.sql)
(upgrades/dbpatches/2.0/mysql/optional.sql).
Everything working well but when it loads screens, it takes long time. I checked mysql queries while it is loading.
Any advice?


mysql> explain SELECT e.* FROM events e WHERE (e.objectid IN ('17626')) AND ((e.objectid BETWEEN 000000000000000 AND 099999999999999)) AND (e.object-0)=0 AND ( (e.value IN ('1')) AND (e.value_changed
IN ('1')) ) ORDER BY e.clock DESC,e.ns DESC LIMIT 1 OFFSET 0;
+----+-------------+-------+------+---------------+------+---------+------+---------+-----------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+---------+-----------------------------+
| 1 | SIMPLE | e | ALL | NULL | NULL | NULL | NULL | 7469971 | Using where; Using filesort |
+----+-------------+-------+------+---------------+------+---------+------+---------+-----------------------------+
1 row in set (0.01 sec)

mysql> SELECT e.* FROM events e WHERE (e.objectid IN ('17626')) AND ((e.objectid BETWEEN 000000000000000 AND 099999999999999)) AND (e.object-0)=0 AND ( (e.value IN ('1')) AND (e.value_changed IN ('1')) ) ORDER BY e.clock DESC,e.ns DESC LIMIT 1 OFFSET 0;
+---------+--------+--------+----------+------------+-------+--------------+----+---------------+
| eventid | source | object | objectid | clock | value | acknowledged | ns | value_changed |
+---------+--------+--------+----------+------------+-------+--------------+----+---------------+
| 5163720 | 0 | 0 | 17626 | 1297341727 | 1 | 0 | 0 | 1 |
+---------+--------+--------+----------+------------+-------+--------------+----+---------------+
1 row in set (2.80 sec)

[richlv]

is there any specific screen widget that's slow ?
was the exact same screen quick in 1.8.5 ? (although i guess that's a different db server with different performance characteristics...)