Forums / Setup & design / 99% CPU for Apache2 after a Reloading

99% CPU for Apache2 after a Reloading

Author Message

David P

Thursday 07 December 2006 6:27:57 am

When I load this tempate all is good but (apache and the render) after a reloading, Apache get 99% of CPU.

My code :

			{def $chemin=array()}
			{def $current_node=$node.parent}

			{while ne($current_node.path_string, "/1/2/")}
				{set $chemin=$chemin|insert($chemin|count()|dec, $current_node)}
				{set $current_node=$current_node.parent}
			{/while}
			
			{if $chemin}
				<ul>
					<li><a href={$chemin_item[0].url_alias|ezurl()}>{$chemin[0].name}</a>
					{set $chemin=$chemin|remove(0)}
					{foreach $chemin as $chemin_item}
						<ul><li>
								<a href={$chemin_item.url_alias|ezurl()}>{$chemin_item.name}</a>
					{/foreach}
					
					{foreach $chemin as $item} 
							</li></ul>
					{/foreach}
					
					{def $nodetofetch=$module_result.content_info.parent_node_id}
			{else}
				<ul><li>{$node.name}
				{def $nodetofetch=$module_result.node_id}
			{/if}

			{def $first_items=fetch( content, list, 
				hash( parent_node_id, 		$nodetofetch, 
				  	  sort_by,				array( 
						array( priority,		false() ),
						array( name,			true() ) ),
					  limit,				50 ) )
			}
			
			{if $first_items}			
				<ul>
					{def $nb=0}
					{foreach $first_items as $first_item}
						<li>
							<a href={$first_item.url_alias|ezurl()}>{$first_item.name}</a>
							
							{if $chemin}

			{def $sub_items=fetch( content, list, 
				hash( parent_node_id, 		$first_item.node_id, 
				  	  sort_by,				array( 
						array( priority,		false() ),
						array( name,			true() ) ),
					  limit,				50 ) )
			}								
								
								{if $sub_items}
									<ul id="ssmenu{$nb}">
										{foreach $sub_items as $sub_item}
											<li><a href={$sub_item.url_alias|ezurl()}>{$sub_item.name}</a></li>
										{/foreach}
									</ul>
								{else}
									<a href={$item.url_alias|ezurl()}>{$item.name}</a>
								{/if}
								
								{set $nb=$nb|inc}
								{undef $sub_items}
							{/if}
						</li>
					{/foreach}
				</ul>
			{/if}
			</li>
			</ul>

eZ debug

Timing: Jan 18 2025 15:10:04
Script start
Timing: Jan 18 2025 15:10:04
Module start 'content'
Timing: Jan 18 2025 15:10:04
Module end 'content'
Timing: Jan 18 2025 15:10:04
Script end

Main resources:

Total runtime0.1439 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.0058 587.8281180.8281
Module start 'content' 0.00580.0046 768.656393.8203
Module end 'content' 0.01040.1334 862.4766523.8281
Script end 0.1438  1,386.3047 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00352.4474200.0002
Check MTime0.00140.9567200.0001
Mysql Total
Database connection0.00080.544910.0008
Mysqli_queries0.099168.85241410.0007
Looping result0.00120.80361390.0000
Template Total0.133192.510.1331
Template load0.00090.616610.0009
Template processing0.132291.865410.1322
Override
Cache load0.00060.448310.0006
Sytem overhead
Fetch class attribute can translate value0.00130.928510.0013
XML
Image XML parsing0.00020.172310.0002
General
dbfile0.00281.9260200.0001
String conversion0.00000.005030.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