Performance of interface web

[cristhiano]

I have Nagios and study migrate to Zabbix. But interface web is very slow.
Today, my situation is:
4150 hosts with 2 items (icmping and icmpingsec). Or, 4150 hosts, 8300 items , 12500 triggers and 100 groups.

The screen of Monitoring->Overview->Data for all groups delay 8 min to complete. Without execute zabbix-server and in the same machine of postgres/apache.

I change file "items.inc.php" in line 889 to:

$header=array_merge($header,array(new CCol($hostname,'txtvert')));

To remove images of text in vertical (each image =~ 1kB * 4150 hosts = 4MB), and delay go to 1 min. But, is very slow.

I tunning Postgres, but not resolve.

I think the optimization of queries is the way to improve delay.

Suggestions ?????

The Nagios is best ????

[Alexei]

IThe screen of Monitoring->Overview->Data for all groups delay 8 min to complete. Without execute zabbix-server and in the same machine of postgres/apache.

Suppose it will be rendered in 0.0001 second. Will it really help? The overview screen is not very useful for 4K of hosts anyway....

[cristhiano]

Thinking small.

[cristhiano]

I studied the log of sql and suggest reconstruct functions of rights of users.File: include/perm.inc.php

[kyi]

take a look here, same problem. I´m waiting for the next release and hope the permission checks will be better -> http://www.zabbix.com/forum/showthre...?t=8040&page=3

[cristhiano]

take a look here, same problem. I´m waiting for the next release and hope the permission checks will be better -> http://www.zabbix.com/forum/showthre...?t=8040&page=3

Kyi,

I comment in file include/perm.inc.php, function get_accessible_hosts_by_user, line 177:

//$host_data += DBfetch(DBselect('select * from hosts where hostid='.$host_data['hostid']));

and this no affect nothing and reduce delay of overview interface.