Zabbix 1.8 Frontend seems slow

[untergeek]

The Zabbix 1.8 frontend seems slower than the one in 1.6

I can think of any number of reasons this could be:

1. PHP is slow for some reason (updated to PHP 5.3.x)
2. The number of queries on Hosts page is much larger with the new columns (Applications, Items, Templates, Graphs)
3. PHP not optimized
4. ???

Database responsiveness is unchanged, though as observed there are more queries needed to render some of the new pages. What kind of optimizations can I pursue to speed things along?

The new zabbix_server allows for caching and such. This only helps the server and not the frontend, though. Is there a similar caching feature I can enable for PHP 5.3.x?

[richlv]

you could try enabling compression (deflate module for apache, or similar).
before doing that, you can try enabling debugging for your usergroup and checking out whether it spends more time on sql queries or php magic

[untergeek]

I have enabled mod_deflate (did that days ago, in fact) and it should all be as speedy as can be. I think it's just that there are so many more queries on the host pages (counts for hosts, items, triggers, graphs for each host). If I do host all it takes 36 seconds to come around again!

Other pages with fewer queries (e.g. only one host on the page) come back much snappier. It really boils down to the increased number of queries per page, I think.

[Twirrim]

You may see some benefits from enabling an opcode cache program to cache the compiled PHP code:

http://pecl.php.net/package/APC

[untergeek]

I looked at APC, but it appeared to only have architectures i386 and x86_64.

We're a SPARC Solaris shop.

[Twirrim]

I looked at APC, but it appeared to only have architectures i386 and x86_64.

We're a SPARC Solaris shop.

Hmm.. well the good news is that APC is integral from PHP6 onwards, but that won't help you at the moment.

I haven't got access to any SPARC Solaris hardware at the moment, but maybe you'll have good mileage with eAccelerator or XCache?

edit: http://blogs.sun.com/vanga/entry/pri..._with_sugarcrm that suggests it should be possible with SPARC & Solaris?

[Palmertree]

This seem to help speed up our site some. Uncomment out the select_nodes check so that web.nodes.selected is not updated a few times on each page access.

--- /root/zabbix-original/frontends/php/include/nodes.inc.php   2009-12-04 16:05:24.000000000 -0500
+++ /root/zabbix/frontends/php/include/nodes.inc.php    2009-12-09 14:12:10.000000000 -0500
@@ -98,7 +98,7 @@
                                $ZBX_CURMASTERID = $ZBX_LOCMASTERID;
                        }

-                       // if(isset($_REQUEST['select_nodes']))
+                        if(isset($_REQUEST['select_nodes']))
                                // update_profile('web.nodes.selected', $ZBX_VIEWED_NODES['nodeids'], PROFILE_TYPE_ARRAY_ID);
                        update_node_profile($ZBX_VIEWED_NODES['nodeids']);
                        if(isset($_REQUEST['switch_node']))