Forums / Setup & design / Database Calls & Variables

Database Calls & Variables

Author Message

Alex Jones

Tuesday 02 December 2003 1:06:27 pm

I have some attributes of a class that are displayed multiple times on a page, for example I have a price that is written in at least three different spots on the page. Does eZ publish hit the database for each of these, or are they already set? If they are already set, is there any overhead to calling them repeatedly via a call like {attribute_view_gui attribute=$content_version.data_map.item_1_price} ?

At this point I am playing with the idea of pulling the price once and setting it in a variable for the entire page as I believe that should cut down on calls to MySQL, but I want to ensure my understanding is correct.

So, it boils down to this question: Do I gain any performance improvements by setting 'price1=$node.data_map.item_1_price.data_float' once at the top of the template and then using {$price1} to display the price compared with {attribute_view_gui attribute=$content_version.data_map.item_1_price}?

Any help would be greatly appreciated!

Alex

[Edited after first posting]

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Alex Jones

Thursday 04 December 2003 6:22:14 am

Anyone?

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Jan Borsodi

Thursday 04 December 2003 8:02:24 am

You can gain some performance improvement by doing this.
The other benefit is that the template is usually easier to read.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Alex Jones

Thursday 04 December 2003 8:47:49 am

Thanks Jan! I thought it would help, and as you mention it makes the templates much easier to read as I have some complicated section show statements throughout the template.

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

eZ debug

Timing: Jan 19 2025 01:12:18
Script start
Timing: Jan 19 2025 01:12:18
Module start 'content'
Timing: Jan 19 2025 01:12:19
Module end 'content'
Timing: Jan 19 2025 01:12:19
Script end

Main resources:

Total runtime0.7492 sec
Peak memory usage4,096.0000 KB
Database Queries197

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0070 588.9531180.8359
Module start 'content' 0.00700.5787 769.7891554.9922
Module end 'content' 0.58570.1635 1,324.7813336.7813
Script end 0.7491  1,661.5625 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00400.5367210.0002
Check MTime0.00150.1996210.0001
Mysql Total
Database connection0.00070.091510.0007
Mysqli_queries0.661188.23721970.0034
Looping result0.00240.31871950.0000
Template Total0.720496.120.3602
Template load0.00220.293020.0011
Template processing0.718295.852420.3591
Template load and register function0.00020.023010.0002
states
state_id_array0.00100.133610.0010
state_identifier_array0.00080.109120.0004
Override
Cache load0.00180.2387210.0001
Sytem overhead
Fetch class attribute can translate value0.00180.234930.0006
Fetch class attribute name0.00120.157960.0002
XML
Image XML parsing0.00170.230930.0006
class_abstraction
Instantiating content class attribute0.00000.001880.0000
General
dbfile0.00420.5543340.0001
String conversion0.00000.000930.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
4content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 15
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs