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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 19 2025 01:19:50
Script start
Timing: Jan 19 2025 01:19:50
Module start 'layout'
Timing: Jan 19 2025 01:19:50
Module start 'content'
Timing: Jan 19 2025 01:19:51
Module end 'content'
Timing: Jan 19 2025 01:19:51
Script end

Main resources:

Total runtime0.7454 sec
Peak memory usage4,096.0000 KB
Database Queries98

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0076 590.6875152.6094
Module start 'layout' 0.00760.0047 743.296939.8750
Module start 'content' 0.01230.7314 783.1719762.2656
Module end 'content' 0.74370.0016 1,545.437530.3281
Script end 0.7453  1,575.7656 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00430.5742160.0003
Check MTime0.00210.2815160.0001
Mysql Total
Database connection0.00130.179810.0013
Mysqli_queries0.656988.1348980.0067
Looping result0.00100.1317960.0000
Template Total0.690692.720.3453
Template load0.00230.311920.0012
Template processing0.688392.341520.3441
Template load and register function0.00010.013110.0001
states
state_id_array0.00951.279810.0095
state_identifier_array0.00180.244420.0009
Override
Cache load0.00220.2907700.0000
Sytem overhead
Fetch class attribute can translate value0.00090.118950.0002
Fetch class attribute name0.00060.0825170.0000
XML
Image XML parsing0.00120.154550.0002
class_abstraction
Instantiating content class attribute0.00000.0038200.0000
General
dbfile0.00090.1249220.0000
String conversion0.00000.001640.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
5content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
15content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
19content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
6content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 47
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs