Forums / General / Relate objects and objectrelationlist

Relate objects and objectrelationlist

Author Message

Roy Bøhmer

Sunday 24 October 2004 6:49:18 am

Hi!

As far as I know there are two documented ways to relate objects to each other:
1) the datatype 'ezKeywords'
2) the function 'related objects'

Both has some major disadvantages.
The keywords is a great feature, but with several authors the list list of keywords will soon grow confusingly large. You could also make a list of legal keywords, but it's still volunerable for typos.
The related objects is also great, but because it's used to insert images etc. into xmltxt you loose some control of what content should be listed as related content/downloadable files etc. and what should not.

I've gone public with one site using ezObjectrelationlist (ORL) to do the relation. Later I found this to have some major drawbacks too: When two objects both put the each other in ORL the server times out when saving. (some kind of never ending circle resulting in many entires in ORL – all of the same object.) In addition, when an object is deleted its not deleted from the ORLs its in.

Have I missed something?
I use ORL a lot for selecting topstoies etc, but I start wondering if I don't understand the inner working of that datatype. Anyone have an explanation on how ORL stores its data?

How would you do "the perfect" relation of relating content?

Roy B

eZ debug

Timing: Jan 19 2025 04:41:29
Script start
Timing: Jan 19 2025 04:41:29
Module start 'content'
Timing: Jan 19 2025 04:41:29
Module end 'content'
Timing: Jan 19 2025 04:41:30
Script end

Main resources:

Total runtime0.8108 sec
Peak memory usage4,096.0000 KB
Database Queries183

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0156 590.1016180.8359
Module start 'content' 0.01560.6205 770.9375409.4688
Module end 'content' 0.63610.1745 1,180.4063329.7891
Script end 0.8107  1,510.1953 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00510.6301210.0002
Check MTime0.00180.2280210.0001
Mysql Total
Database connection0.00460.565010.0046
Mysqli_queries0.731190.17871830.0040
Looping result0.00220.26831810.0000
Template Total0.758993.620.3795
Template load0.00230.283320.0011
Template processing0.756693.320420.3783
Template load and register function0.00030.033210.0003
states
state_id_array0.00440.542110.0044
state_identifier_array0.00190.230920.0009
Override
Cache load0.00180.2274150.0001
Sytem overhead
Fetch class attribute can translate value0.00210.253920.0010
Fetch class attribute name0.00080.100610.0008
XML
Image XML parsing0.00050.057620.0002
class_abstraction
Instantiating content class attribute0.00000.000610.0000
General
dbfile0.00230.2877210.0001
String conversion0.00000.001030.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
1content/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
3content/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: 10
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs