Forums / Install & configuration / ezcontentclass.version = '0'

ezcontentclass.version = '0'

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Gernot Rief

Sunday 25 April 2004 9:32:51 am

hi!
we're running into a BIG performace problems using ezp 3.3. (starting conditions: ~300000 objects, ~4500000 attributes, 2x xeon 2G, 2G RAM, hw raid, etc.)
so what we're trying to do is to reduce joins whereever we can.
question:
ezcontentclass.id = ezcontentobject.contentclass_id is this join really necessary.
it seems that ezcontentclass.version = '0' is hardcoded into the scripts and never changes?

lg,
gernot

Jan Borsodi

Monday 26 April 2004 12:59:04 am

Could you please state where (the file) you found the SQL query?
Makes it easier to say if it is needed or not.

--
Amos

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

Gernot Rief

Monday 26 April 2004 1:07:58 am

hi!

there they are (sorry, no line-numbers):

classes/ezcontentobject.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
classes/ezcontentobjecttreenode.php:ezcontentclass.version=0 AND
content/ezcontentfunctioncollection.php:AND ezcontentclass.version=0
content/ezcontentfunctioncollection.php:AND ezcontentclass.version=0
content/ezcontentfunctioncollection.php:AND ezcontentclass.version=0
content/ezcontentfunctioncollection.php:AND ezcontentclass.version=0
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and
search/plugins/ezsearchengine/ezsearchengine.php:ezcontentclass.version = '0' and

lg,
gernot

Jan Borsodi

Tuesday 27 April 2004 4:51:18 am

It is required since there are fields fetched from the ezcontentclass tables, e.g the name is fetched several places. If you know of places where it is no longer needed you can create a bug report for it.

The reason for the ezcontentclass.version = '0' is to only join with classes that are stored, not the temporary ones.

--
Amos

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

eZ debug

Timing: Jan 31 2025 04:24:38
Script start
Timing: Jan 31 2025 04:24:38
Module start 'content'
Timing: Jan 31 2025 04:24:38
Module end 'content'
Timing: Jan 31 2025 04:24:38
Script end

Main resources:

Total runtime0.1600 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.0065 587.9531180.8281
Module start 'content' 0.00650.0054 768.781397.8984
Module end 'content' 0.01190.1480 866.6797526.8047
Script end 0.1599  1,393.4844 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00321.9748200.0002
Check MTime0.00130.8063200.0001
Mysql Total
Database connection0.00090.542510.0009
Mysqli_queries0.114671.64791410.0008
Looping result0.00120.74271390.0000
Template Total0.147792.310.1477
Template load0.00080.491310.0008
Template processing0.146991.835210.1469
Override
Cache load0.00060.345110.0006
Sytem overhead
Fetch class attribute can translate value0.00060.356310.0006
XML
Image XML parsing0.00020.127610.0002
General
dbfile0.00623.8942200.0003
String conversion0.00000.004530.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