why it is very slow?

Next topic

Author	Message
Aleksey Tik	Friday 01 February 2008 6:45:44 am Configuration: eZ Publish 4.0.0, Apache 2.2, PHP 5.2.4, WinXP SP2, MySQL 5.1 evry page opening very long time ( 3-5 sec). I create a trace of eZ. Results are below. preview of diagramm - http://keep4u.ru/imgs/s/080201/38/38212731c700ec259f.jpg full size - http://keep4u.ru/full/080201/38212731c700ec259f/jpg preview of table - http://keep4u.ru/imgs/s/080201/cc/cc13161af59e01d244.jpg full size http://keep4u.ru/full/080201/cc13161af59e01d244/jpg preview of trace http://keep4u.ru/imgs/s/080201/5a/5a183d74db0fbbd6fe.jpg full size http://keep4u.ru/full/080201/5a183d74db0fbbd6fe/jpg if it is first time open page results are worse... preview http://keep4u.ru/imgs/s/080201/2e/2ea7556bc48f6e377a.jpg full size http://keep4u.ru/full/080201/2ea7556bc48f6e377a/jpg preview http://keep4u.ru/imgs/s/080201/dd/dda92549fab7557f48.jpg full size http://keep4u.ru/full/080201/dda92549fab7557f48/jpg preview http://keep4u.ru/imgs/s/080201/ae/ae49963700a4b92529.jpg full size http://keep4u.ru/full/080201/ae49963700a4b92529/jpg as i see - connect to the MySQL demand alot of time. but it spent only 32% of total time.... How can I tune my enviroment for better results? ===================== Also some of offtopic: why i must login twice? If i want to create new post and not loggin in, site redirect me to the login page. After I insert a correct login and password site redirect me to the login page again! And only second login i return to the forum...
André R.	Friday 01 February 2008 9:23:57 am One reason is that PHP performs badly on Windows compared to Linux, this is something they (PHP and Microsoft) are working on but don't expect miracles. One other reason is eZ Publish, it uses a lot of filesystem calls, something NTFS (file system on Windows) handles a lot worse then most filesystems on Linux. Both on Windows and Linux you should look into tweaking PHP, and adding a PHP accellerator (APC or eaccelerator). More here: http://ez.no/developer/forum/general/ez_publish_performance_optimisation_faq http://ez.no/developer/forum/setup_design/improving_ez_publish_environment_and_performance 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
Aleksey Tik	Saturday 02 February 2008 11:41:09 pm Thanks, André. I'll try eZ Publish on Linux next week and try compare it. About filesystem (by the way - i know what is NTFS :) ) - is it have sense placed eZ on RAM disk? The volume of it is not large (32 Mb), so, i can try create RAM-disk... What you think about it?
André R.	Sunday 03 February 2008 8:13:08 am You need a lot more then 32 mb, becuase if you want it to have a effect, you need to have the cache ( but not neciserly the var/*/storage ) on the ram disk. An I recently saw 64Gb used for cache only on a medium install with 9 siteaccesses.. (even though some of the cache size issues on installs with many siteaccesses are looked into). 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
Piotrek Karaś	Sunday 03 February 2008 11:41:19 am > you need to have the cache ( but not neciserly the var//storage ) on the ram disk You mean a RAM cache istead of disk cache in /var/.. ? Any details on how to do that for eZ? -- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu
André R.	Monday 04 February 2008 1:46:46 am No, he was talking about Ram Disk, a hard drive built with ram. Kind of like Solid-state disk, but it will loose all information if it looses power.. Edit: he probably meant this : http://en.wikipedia.org/wiki/RAM_disk , while I thought ha was talking about this: http://en.wikipedia.org/wiki/I-RAM 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
Aleksey Tik	Monday 04 February 2008 5:31:56 am i told about SDD technology, like iRAM...

eZ debug

Timing:	Jan 18 2025 11:26:34
Script start
Timing:	Jan 18 2025 11:26:34
Module start 'layout'
Timing:	Jan 18 2025 11:26:34
Module start 'content'
Timing:	Jan 18 2025 11:26:34
Module end 'content'
Timing:	Jan 18 2025 11:26:34
Script end

Main resources:

Total runtime	0.7170 sec
Peak memory usage	4,096.0000 KB
Database Queries	71

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0046	588.9063	152.6094
Module start 'layout'	0.0046	0.0033	741.5156	39.4297
Module start 'content'	0.0080	0.7076	780.9453	635.4141
Module end 'content'	0.7155	0.0014	1,416.3594	20.1875
Script end	0.7170		1,436.5469

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4381	16	0.0002
Check MTime	0.0013	0.1772	16	0.0001
Mysql Total
Database connection	0.0007	0.0963	1	0.0007
Mysqli_queries	0.6526	91.0211	71	0.0092
Looping result	0.0006	0.0888	69	0.0000
Template Total	0.6894	96.2	2	0.3447
Template load	0.0029	0.4107	2	0.0015
Template processing	0.6865	95.7436	2	0.3432
Template load and register function	0.0002	0.0244	1	0.0002
states
state_id_array	0.0007	0.1000	1	0.0007
state_identifier_array	0.0008	0.1059	2	0.0004
Override
Cache load	0.0019	0.2660	46	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0009	0.1323	3	0.0003
Fetch class attribute name	0.0009	0.1293	9	0.0001
XML
Image XML parsing	0.0013	0.1840	3	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0030	11	0.0000
General
dbfile	0.0009	0.1256	24	0.0000
String conversion	0.0000	0.0012	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
7	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
10	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
15	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 38 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs