Forums / Developer / Maximum Execution Time Error

Maximum Execution Time Error

« 
Previous topic
|
Developer
|
Next topic
 »
Author Message

Masamune

Monday 13 June 2005 6:05:03 am

My database exceeded 30 mb of size, The left panel in the admin interface became very heavy and if expanded the site won't open:
-maximum exectution time exceeded 30 sec...
-tcp error

I tried to override the setup.ini and set the maximum exec. time to 60 sec. and the min memory to 32 mb, but no use, even it's not taking the override, i.e still 30 displaying sec.

Please can anyone at least guide me what are the steps that I refer to to

Łukasz Serwatka

Thursday 16 June 2005 2:37:44 am

Hi,

You can override settings/contentstructuremenu.ini file and display only folder class to 3 depth level for example. This should reduce server load.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

François Xavier Lacroix

Thursday 16 June 2005 3:13:05 am

Did you put 30 sec max execution time, in the php.ini too ?

Masamune

Sunday 19 June 2005 5:14:43 am

Thank u guys, u r really helpful.

I modified the execution time in php.ini to 120 sec and increased the cache to 32mb, it worked.
Now this contentstructuremenu.ini seems interesting, I better have a look on it.

I believe I have to make some further optimizations on the database level.
Recently I knew that mysql should be configured to handle big databases.

10x.

eZ debug

Timing: Jan 18 2025 21:14:23
Script start
Timing: Jan 18 2025 21:14:23
Module start 'content'
Timing: Jan 18 2025 21:14:23
Module end 'content'
Timing: Jan 18 2025 21:14:24
Script end

Main resources:

Total runtime0.1436 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0063 587.7109180.8359
Module start 'content' 0.00630.0053 768.546997.8672
Module end 'content' 0.01160.1319 866.4141526.2734
Script end 0.1436  1,392.6875 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00402.7908200.0002
Check MTime0.00171.1491200.0001
Mysql Total
Database connection0.00070.492310.0007
Mysqli_queries0.100670.02031410.0007
Looping result0.00130.87421390.0000
Template Total0.131691.610.1316
Template load0.00090.644710.0009
Template processing0.130790.986110.1307
Override
Cache load0.00070.462310.0007
Sytem overhead
Fetch class attribute can translate value0.00090.634210.0009
XML
Image XML parsing0.00020.151210.0002
General
dbfile0.00191.3463200.0001
String conversion0.00000.004030.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.0001 secs