Forums / General / why it is very slow?

why it is very slow?

« 
Previous topic
|
General
|
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 30 2025 19:42:06
Script start
Timing: Jan 30 2025 19:42:06
Module start 'content'
Timing: Jan 30 2025 19:42:06
Module end 'content'
Timing: Jan 30 2025 19:42:06
Script end

Main resources:

Total runtime0.2879 sec
Peak memory usage8,192.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0098 587.8281370.3125
Module start 'content' 0.00980.0192 958.14061,009.4531
Module end 'content' 0.02900.2588 1,967.59383,899.8984
Script end 0.2878  5,867.4922 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00642.2343200.0003
Check MTime0.00160.5597200.0001
Mysql Total
Database connection0.00120.430410.0012
Mysqli_queries0.176261.19101410.0012
Looping result0.00170.57961390.0000
Template Total0.257289.310.2572
Template load0.00150.532510.0015
Template processing0.255788.805010.2557
Override
Cache load0.00080.291810.0008
Sytem overhead
Fetch class attribute can translate value0.00220.756910.0022
XML
Image XML parsing0.00050.157410.0005
General
dbfile0.00722.5174200.0004
String conversion0.00000.002730.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs