Maximum of nodes

Next topic

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 09:13:42
Script start
Timing:	Jan 19 2025 09:13:42
Module start 'layout'
Timing:	Jan 19 2025 09:13:42
Module start 'content'
Timing:	Jan 19 2025 09:13:43
Module end 'content'
Timing:	Jan 19 2025 09:13:43
Script end

Main resources:

Total runtime	0.8048 sec
Peak memory usage	4,096.0000 KB
Database Queries	62

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	589.0313	152.6094
Module start 'layout'	0.0058	0.0036	741.6406	39.4063
Module start 'content'	0.0094	0.7940	781.0469	578.5391
Module end 'content'	0.8034	0.0013	1,359.5859	12.1953
Script end	0.8047		1,371.7813

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.3744	16	0.0002
Check MTime	0.0013	0.1560	16	0.0001
Mysql Total
Database connection	0.0014	0.1727	1	0.0014
Mysqli_queries	0.7537	93.6547	62	0.0122
Looping result	0.0007	0.0845	60	0.0000
Template Total	0.7725	96.0	2	0.3862
Template load	0.0024	0.2925	2	0.0012
Template processing	0.7701	95.6936	2	0.3851
Template load and register function	0.0002	0.0188	1	0.0002
states
state_id_array	0.0009	0.1127	1	0.0009
state_identifier_array	0.0010	0.1193	2	0.0005
Override
Cache load	0.0019	0.2409	24	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0692	3	0.0002
Fetch class attribute name	0.0013	0.1672	5	0.0003
XML
Image XML parsing	0.0011	0.1325	3	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0014	5	0.0000
General
dbfile	0.0015	0.1884	16	0.0001
String conversion	0.0000	0.0008	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 16 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs