Maximum Execution Time Error

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.

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

eZ debug

Timing: Jan 31 2025 04:34:02
Script start
Timing: Jan 31 2025 04:34:02
Module start 'layout'
Timing: Jan 31 2025 04:34:02
Module start 'content'
Timing: Jan 31 2025 04:34:02
Module end 'content'
Timing: Jan 31 2025 04:34:02
Script end

Main resources:

Total runtime0.0240 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0059 589.2656151.2109
Module start 'layout' 0.00590.0023 740.476636.6484
Module start 'content' 0.00830.0140 777.125094.1406
Module end 'content' 0.02220.0017 871.265633.9922
Script end 0.0239  905.2578 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002911.9443140.0002
Check MTime0.00156.1055140.0001
Mysql Total
Database connection0.00083.414510.0008
Mysqli_queries0.002711.395030.0009
Looping result0.00000.050810.0000
Template Total0.00114.810.0011
Template load0.00093.852410.0009
Template processing0.00020.926510.0002
Override
Cache load0.00072.721910.0007
General
dbfile0.006326.456280.0008
String conversion0.00000.117440.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_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