Forums / General / Maximum of nodes

Maximum of nodes

Author Message

Martin Simek

Sunday 11 December 2005 10:31:16 pm

Hello,
a little, but important question: Is by anything limited maximal number of nodes that eZ publish can contains? and is limited maximal number of users?

I ask you, bacause my server (where we are using eZ) is at start and now contains about 700 nodes, but in the future that number may be up to 20.000 (articles, folder, etc.). And I will have to have up to 300 users with different permissions.

[Table "ezsearch_object_word_link" makes me slightly worry. Now when system contains 700 nodes, this table have around 65.000 rows!]

Please, give me your advice about great numbers of nodes.

Thanks,
Martin

Bruce Morrison

Sunday 11 December 2005 10:43:34 pm

Hi Martin

Node info is stored in ezcontentobject_tree it's primary_key is stored at int(11) so this will be the number of nodes the system will support (well within 20,000 :).

However it's the a ezcontentobject_attribute table that will cause problems before you run out of nodes. It's primary keys is also int(11) and you ususally have multiple attributes per content_object not to mention versions.

Assuming that php will handle ints of this size your site will have to have quite a few objects/nodes before you run into these limits.

Be good to get some definative upper limits from eZ though.

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Gabriel Ambuehl

Monday 12 December 2005 1:09:23 am

It would seem to me that those ints are rather theoretically hard upper limits. Much more important would be data about scalability. I doubt you'll be able to hold 32bit int worth of atttribute data (that'd be 4billion plus records) without choking the system much sooner. FWIW, ez.no seems to currently be at about 105000 contentobjects, so 20000 should be well within reach on appropriate hardware.

Visit http://triligon.org

Martin Simek

Thursday 15 December 2005 6:58:43 am

Thank you very much for answers!

Martin Simek

eZ debug

Timing: Jan 19 2025 11:55:32
Script start
Timing: Jan 19 2025 11:55:32
Module start 'content'
Timing: Jan 19 2025 11:55:32
Module end 'content'
Timing: Jan 19 2025 11:55:33
Script end

Main resources:

Total runtime0.2942 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.0108 588.8203180.8516
Module start 'content' 0.01080.0159 769.671993.7969
Module end 'content' 0.02670.2674 863.4688522.4844
Script end 0.2942  1,385.9531 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00401.3671200.0002
Check MTime0.00150.5183200.0001
Mysql Total
Database connection0.00080.282810.0008
Mysqli_queries0.213772.63711410.0015
Looping result0.00200.68321390.0000
Template Total0.266990.710.2669
Template load0.00100.338910.0010
Template processing0.265990.384010.2659
Override
Cache load0.00060.218510.0006
Sytem overhead
Fetch class attribute can translate value0.00110.361210.0011
XML
Image XML parsing0.00030.091810.0003
General
dbfile0.02207.4706200.0011
String conversion0.00000.005730.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.0004 secs