Forums / Install & configuration / Very slow admin interface

Very slow admin interface

Author Message

Pascal France

Saturday 11 April 2009 11:37:37 am

Hi,

I face with a very slow admin interface (about 35 seconds each time I click on a content tree's node).

The debug output can be seen here:
http://linuxorable.fr/tmp/realy_slow_admin_inerface.png
and the end of this screenshot ends with this table of statistics:
http://linuxorable.fr/tmp/realy_slow_admin_inerface_2.png

Is there someone who can explain me what means the debug output messages ?

I use eZ Publish 3.9.4, MySQL 5.0.32, PHP 4.4.4 and apache 2.2.3

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Damien Pobel

Sunday 12 April 2009 2:41:34 pm

Hi Pascal,

682 MySQL queries ! It seems that caches are disabled, you should check the following settings in site.ini (use /settings/view in your admin interface) :
* [ContentSettings]/ViewCaching
* [TemplateSettings]/TemplateCompile
* [TemplateSettings]/TemplateCache

Cheers

Damien
Planet eZ Publish.fr : http://www.planet-ezpublish.fr
Certification : http://auth.ez.no/certification/verify/372448
Publications about eZ Publish : http://pwet.fr/tags/keywords/weblog/ez_publish

André R.

Sunday 12 April 2009 3:43:00 pm

and changing your settings to something like

[TemplateSettings]
Debug=disabled
ShowXHTMLCode=disabled
# better to use this to see witch templates are used then the ones above, but disable in production
ShowUsedTemplates=enabled
TemplateCompile=enabled
TemplateCache=enabled
# enable during development, makes the code check modified time on templates (clear compiled cache when you change this!)
DevelopmentMode=disabled

And install ezjaxx or any other ajax content structure menu extension.

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

eZ debug

Timing: Jan 18 2025 21:02:04
Script start
Timing: Jan 18 2025 21:02:04
Module start 'content'
Timing: Jan 18 2025 21:02:05
Module end 'content'
Timing: Jan 18 2025 21:02:05
Script end

Main resources:

Total runtime0.8534 sec
Peak memory usage4,096.0000 KB
Database Queries196

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0069 588.8672180.8281
Module start 'content' 0.00690.7183 769.6953589.6719
Module end 'content' 0.72520.1282 1,359.3672336.7734
Script end 0.8533  1,696.1406 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.4581210.0002
Check MTime0.00150.1744210.0001
Mysql Total
Database connection0.00070.077610.0007
Mysqli_queries0.781591.57211960.0040
Looping result0.00220.25321940.0000
Template Total0.816895.720.4084
Template load0.00250.293520.0013
Template processing0.814295.413220.4071
Template load and register function0.00010.016410.0001
states
state_id_array0.00110.128810.0011
state_identifier_array0.00180.209120.0009
Override
Cache load0.00210.2473250.0001
Sytem overhead
Fetch class attribute can translate value0.00110.123140.0003
Fetch class attribute name0.00120.137050.0002
XML
Image XML parsing0.00110.133440.0003
class_abstraction
Instantiating content class attribute0.00000.001350.0000
General
dbfile0.00300.3530340.0001
String conversion0.00000.004630.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 16
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs