Forums / Setup & design / Ojects Relation and huge number of objects.

Ojects Relation and huge number of objects.

« 
Previous topic
|
Setup & design
|
Next topic
 »
Author Message

laurent le cadet

Monday 11 May 2009 5:47:03 am

Hi,

I have a "Wine" classe and I want to like it with reciepes via objects relation.

Objects relation is very handy and I want to use it like this:

- Check boxes list
- 1 pre-selected classe

Handy because no need to browse while creating objects.

At the end there will be about 200 objects which will be concerned by the datatype.
Will it be till performant or is there a best method?

Best regards.

Laurent

André R.

Monday 11 May 2009 12:34:29 pm

Should be ok in newer versions, but you might need to override templates in admin so it 1. is UI workable and 2. doesn't get to slow because of to many fetched related objects.

PS: limit and offset parameters on related object fetches where added in 4.1

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

laurent le cadet

Monday 11 May 2009 11:25:58 pm

André,

This is an eZp 3.10.1 :)
So If it becomes too slow, I will change the datatype method to browse.

Thanks.

Laurent

eZ debug

Timing: Jan 18 2025 22:35:21
Script start
Timing: Jan 18 2025 22:35:21
Module start 'content'
Timing: Jan 18 2025 22:35:21
Module end 'content'
Timing: Jan 18 2025 22:35:22
Script end

Main resources:

Total runtime0.1423 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 593.9141180.8125
Module start 'content' 0.00580.0053 774.726693.9297
Module end 'content' 0.01110.1312 868.6563522.6250
Script end 0.1422  1,391.2813 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00322.2423200.0002
Check MTime0.00130.9205200.0001
Mysql Total
Database connection0.00050.378710.0005
Mysqli_queries0.102371.89931410.0007
Looping result0.00120.81581390.0000
Template Total0.130992.010.1309
Template load0.00060.435710.0006
Template processing0.130391.556810.1303
Override
Cache load0.00040.310510.0004
Sytem overhead
Fetch class attribute can translate value0.00080.527210.0008
XML
Image XML parsing0.00030.181310.0003
General
dbfile0.00161.1382200.0001
String conversion0.00000.003430.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