I read all about ez performance, but admin part is slow...

Tuesday 05 December 2006 5:58:54 am

I have refresh time a page in admin interface about 3-10 sec. Is normal? I think is slow :( ... All pages is cached.

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Module start 'content'	0.0000 sec	2.4954 sec	0.0000KB	0.0000KB
Module end 'content'	2.4954 sec	2.8317 sec	0.0000KB	0.0000KB
End	5.3271 sec	 	0.0000KB	0.0000KB
Total runtime:	5.6019 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0486 sec	0.8438%	15	0.0032 sec
FindInputFiles	0.0355 sec	0.6165%	15	0.0024 sec
Mysql Total				
Mysql_queries	0.2719 sec	4.7241%	116	0.0023 sec
Looping result	0.0291 sec	0.5057%	110	0.0003 sec
TS translator				
TS init	0.0400 sec	0.6950%	8	0.0050 sec
TS cache load	0.0151 sec	0.2622%	8	0.0019 sec
TS context load	0.0120 sec	0.2085%	8	0.0015 sec
Template Total	5.3367 sec	92.7%	3	1.7789 sec
Template load	0.0478 sec	0.8306%	3	0.0159 sec
Template processing	5.2881 sec	91.8765%	3	1.7627 sec
Template load and register function	0.0005 sec	0.0082%	1	0.0005 sec
override				
Cache load	0.0338 sec	0.5865%	4	0.0084 sec
class_abstraction				
Instantiating content class attribute	0.0133 sec	0.2314%	7	0.0019 sec
General				
dbfile	0.0571 sec	0.9926%	239	0.0002 sec
Total script time:	5.7556 sec	

My info is:
windows 2000
ez: 3.8.6 (3.8.6)
Apache/1.3.33 (Win32) PHP/4.4.4
eAccelerator 0.9.4
Athlon 2500+, 1Gb memory
mysql 4.1.16

plain_site_admin:
site.ini.append.php

....
[ContentSettings]
ViewCaching=enable
PreViewCache=enabled

[TemplateSettings]
Debug=enabled
NodeTreeCaching=enabled
TemplateCache=enable
TemplateCompile=enabled
TemplateOptimization=enabled
ShowXHTMLCode=enabled
ShowUsedTemplates=enabled

[OverrideSettings]
Cache=enabled

[SearchSettings]
DelayedIndexing=enabled
.....

php.ini:

max_execution_time = 100
memory_limit = 128M
max_input_time = 60

extension="eaccelerator.dll"
eaccelerator.shm_size="256"
eaccelerator.cache_dir="/tmp/eaccelerator"
eaccelerator.enable="1"
eaccelerator.optimizer="1"
eaccelerator.check_mtime="1"
eaccelerator.debug="0"
eaccelerator.filter=""
eaccelerator.shm_max="0"
eaccelerator.shm_ttl="0"
eaccelerator.shm_prune_period="0"
eaccelerator.shm_only="0"
eaccelerator.compress="1"
eaccelerator.compress_level="9"  

Thank you!

Wednesday 06 December 2006 3:12:47 am

Lukasz, thank you for you reply!

I found some part of a poblem: several week ago i installed "[eZjaxx] Ajax Admin" extension. It description say: "A Ajax / speed up extension for eZ Publish 3.8 / 3.9, more:" But it is slower! I uninstall it and now the refresh time page is 2-3 sec. Browse other page 4-5 sec. I have about 100-150 objects in the content tree. It is normal refresh time ?
I think if i enable all caches, refresh time must be less 1 sec. Why admin interface make more 146 SQL queries and a template processing time 2-5 sec if i enabled all caches ?

Wednesday 06 December 2006 3:41:54 am

Hi,

what version of eZjaxx did you use ?
And how big site is this ?

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Wednesday 06 December 2006 4:02:08 am

ok, yes 0.3 where quite experimental.
Somewhere around version 0.7 and 0.8 I did a lot of changes to that menu because of poor performance on some systems.

So if you could take a couple of minutes testing a newer version, that will probably help a lot!
And could you also post back with feedback about this?

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Wednesday 06 December 2006 5:32:58 am

Thats because ezjaxx is a ajax menu, elements not shown when you load the page is dynamicly loaded with ajax / xmlhttprequest in the background when you click expand (+).
Without it, every single node of the node tree is loaded on each page load, a really bad idea on large sites(really huge (x)html tree, and quite heavy on the database side to).

I / Paul or others willing to contribute will look into speeding up the expand function in the future. (by doing the sql calls directly with eZDB and avoid using the template system)

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Wednesday 06 December 2006 6:42:07 am

Thank you, André R!

I try set

NodeTreeCaching=disabled

but a refresh speed not impoved.

But i transfered 60 nodes from main node to speshial folder, and now main node have only 10 nodes and i see a good speed up! Refresh page is 1-3 sec, and number sql queries decrease from 156 to 60. But i don't undestand why the content menu don't cached although i setup a full caching.