Forums / General / Object Relations

Object Relations

Author Message

Kristof Coomans

Tuesday 30 August 2005 6:10:05 am

I've made an extension with some functions and templates to show the attribute relations in a window in the full view of the admin interface.

You can find it in the contributions area:
http://ez.no/community/contribs/hacks/advanced_content

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

newave france

Tuesday 30 August 2005 9:58:17 am

I've just installed the last extension "advanced_content", it's THE solution that solve a big part of my problems, thanks.

An important question.

How many content and relations Ez Publish is able to manage ? Is it possible to use it for a big content website, with :
-more than 10 000 contents (news, article, reviews, tutorials),
-1 000 categories (defined with related_objects)
-and a big activity (20 000 unique visitor per day)?

Will it be to slow on a normal dedicates server ?

Thanks for your analyse on this important subject.

;-)

Gabriel Ambuehl

Tuesday 30 August 2005 10:28:23 am

Is the content being served to the users essentially static or highly customized to them?

Visit http://triligon.org

newave france

Tuesday 30 August 2005 2:41:01 pm

Hi Gabriel,

we'd like a static version of all content (articles, news, tutorials, reviews...) for better referencement (google...). For forums we have another technologie (VBulletin).

We will generate some content directly in the Ez admin interface (articles, news) but a lot of another will be generated by the communauty (reviews of products, tutorials, comments...). All this contents have to be categorized with a complexe architecture (each content will be categorized with a selection of 20 categories selected into the total list of our 1000 categories).

Hope my answer can be understand...

Best Regards

Gabriel Ambuehl

Tuesday 30 August 2005 11:53:22 pm

Have alook at the static cache in 3.6 it might or might not do what you're after. If you have the forums outside ezpublish, that likely helps.

For reference, I can generate about 5-10 pages per second on a 3ghz machine (all dynamic caching on, not static) and easily a few hundreds (at which point disk IO needs to be fast) static pages.

Visit http://triligon.org

Xavier Dutoit

Wednesday 31 August 2005 12:32:24 am

Salut newave france,

It shouldn't be too complicated and with the cache, it should be ok. As for the editing, you can tune ez to save some time too (eg postpone the indexing and do it by cron).

As for eor, it's possible to rewrite some part of the code to avoid some sql queries... if you have a speed issue and a budget for it, I'll be more than happy to help you ;)

X+

http://www.sydesy.com

newave france

Wednesday 31 August 2005 1:07:23 am

Thanks Gabriel and Xavier for these very important answers. So, it seems to be possible to do it if we manage it after a good analyse of the perfect method to execute...

Xavier, thanks for your proposition. I had already noticed that you're a serious specialist of developpement with EZ, so if we need help or special developpement or an analyse of our projet, we know that we can call you for a prestation. You are in France aren't you ? Were exacttly ? You can mail me at :
sloane3 AT free .fr

Best Regards...

Gabriel Ambuehl

Wednesday 31 August 2005 1:12:06 am

If Xavier ain't got the time when you'd need him, you could also ask me. Seeing that he's Swiss French (whereas I'm Swiss German and my French is, uhm, nothing to write home about) it might be easier for you to deal with thim though.

Visit http://triligon.org

Kirill Subbotin

Monday 12 September 2005 6:34:41 am

Your suggestions on fetch functions and admin interface are implemented in latest trunk (rev. 13263),
See /doc/features/3.8/related_objects_fetch_functions.txt for details.

Please comment, is that exactly solve the problem in your opinion ?

Gabriel Ambuehl

Monday 12 September 2005 6:40:22 am

I'll try to look at it some time this week if I find the time. I'll surely do it until the end of September.

Thanks for the headsup!

Visit http://triligon.org

Xavier Dutoit

Monday 12 September 2005 4:14:21 pm

Hi Kirill,

Any chance to see that on the 3.5/3.6/3.7 branches ?

I'm not that afraid of the bleeding edge, but I'm having enough problem with 3.5 and 3.6 these days...

X+

http://www.sydesy.com

Kirill Subbotin

Thursday 15 September 2005 1:49:07 am

Hi !
We decided not to put it into stable branches, but you can apply it as a patch there, see my commits rev. 13235, 13251, 13263 to trunk. Or I can send the diffs to you if you need it.

Gabriel Ambuehl

Thursday 15 September 2005 2:01:17 am

Thanks a lot!

Visit http://triligon.org

Xavier Dutoit

Thursday 15 September 2005 5:33:34 am

Hi Kirill,

Could you attach the patch to gabriel bug report so everyone can benefit from it ?

Update :
kirill posted the patches. many thanks

http://ez.no/community/bugs/treatment_of_related_object_with_attributeid_set

X+

http://www.sydesy.com

Kristof Coomans

Thursday 05 January 2006 3:26:15 am

I believe the documentation site should be updated with the new functionality of these patches.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

eZ debug

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

Main resources:

Total runtime0.2896 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.0077 588.1094180.8516
Module start 'content' 0.00770.0054 768.9609110.1953
Module end 'content' 0.01310.2764 879.1563540.2344
Script end 0.2895  1,419.3906 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00341.1885200.0002
Check MTime0.00140.4676200.0001
Mysql Total
Database connection0.00080.288310.0008
Mysqli_queries0.239482.65901410.0017
Looping result0.00150.51361390.0000
Template Total0.276195.310.2761
Template load0.00080.277310.0008
Template processing0.275395.059510.2753
Override
Cache load0.00060.194810.0006
Sytem overhead
Fetch class attribute can translate value0.00090.310210.0009
XML
Image XML parsing0.00020.068310.0002
General
dbfile0.00692.3723200.0003
String conversion0.00000.002730.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.0002 secs