why it is very slow?

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...

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.