What is the maximum number of child nodes?

Narisorn Pongpanich asked on November 2, 2014 23:46

Hi,

Just wonder are there any limitations on the number of child nodes per 1 parent node? eg if I have 3,000 nodes just under 1 parent. I don't think there would be any problems on the db structure. But I just concerned on the performance issue.

Thanks

Recent Answers


Thirumurugan Sankaran answered on November 3, 2014 11:57

we had requirement to develop the CMS site using Kentico 7. So, actually we should create some page template use it across the site commonly. I come to the point,

             we imported sites objects into existing site from some other sites(Kentico SIte), After that we supposed to create one page template in CMS site Manager, that will not reflect into CMS Desk, whenever creating new page menu items(it's not visible, whatever we have created in SIte manager), but accordingly Kentico 7 documentation its should be shown in CMSDesk.

             I think you will get my point, please find this issue and revert back, waiting your reply
0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on November 3, 2014 13:35

@Narisorn, there isn't a limitation to the number of child nodes per parent node. There are a few things you'll want to look at though:

  1. If you're importing these on a scheduled/regular basis, would they be better in a custom table?
  2. Do you have a search index setup for those objects?
  3. There is a setting that states how many are shown in the content tree, adjust as needed (System > User interface>Max UI tree nodes)
  4. Review the Performance Whitepaper. Yes it is for v6 but it gives you an idea and can only get better.
0 votesVote for this answer Mark as a Correct answer

Virgil Carroll answered on November 3, 2014 14:59

As Brenden said there really isn't a limitation, but I just asked this question recently because of a project I am working on for a client where there will be a lot of nodes under a single parent. The Kentico recommendation is to keep it under 100k, but I have a feeling that is probably a threshold you don't want to test without having a solid infrastructure.

I am also going to send along this recommendation from Kentico as well when dealing with large sets of child nodes:

There is one settings particular related to your question. If you go to Settings -> System -> Max UI tree nodes. This settings how many nodes will be visible under parent node. By default this value is 100 and I would probably recommend to keep it this way since you can browse all documents easily using the List mode instead.

0 votesVote for this answer Mark as a Correct answer

Charles Matvchuk answered on November 3, 2014 15:12

Currently I have 684,217 custom documents (pages) in Kentico 8.1 system. One of my nodes has 220,000 it is working fine and I am not seeing any degradation in performance whatsoever.

1 votesVote for this answer Mark as a Correct answer

Martin Danko answered on November 3, 2014 16:30 (last edited on November 3, 2014 16:30)

Hello,

I would also recommend you to read the following article which is discussing performance aspects for such a scenario: Architecture matters!

Best regards, Martin

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on November 3, 2014 19:30

@Charles,

That's awesome! I'm curious about the site now...

  • Is the site public facing or intranet?
  • How much traffic does the site get on a daily and monthly basis?
  • Regarding the documents, are they all managed within Kentico or imported?
  • Are any doc types setup for design or SEO purposes or are they all strictly pages?
0 votesVote for this answer Mark as a Correct answer

Chetan Sharma answered on August 14, 2015 14:28

Hi Brenden, Martin & Charles,

We also wanted to build a system using Kentico that will server products through various means to other systems. There are around 20K products in the system. A strong and robust Page/Form feature is required for us. THis will ensure ease of contribution. We also want have a workflow system around approval of products and publishing. An extra feature of the system is to provide Search around products.

Other features are Hierarchy, Tagging extra.

THis will mostly be an internal website that will act as source for various other system that will be fed with this?

Do you think using Kentico CMS Out of the Box(As it is) will be suitable for us?

Thanks Chetan

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on August 18, 2015 13:35

Hi guys,

Right now, in Kentico 8 is recommended to have no more that 100k of pages in total and no more than 1k of child nodes. Having more child nodes under one parent can have negative effect when using content staging or for example renaming the parent - the change has to be done to all children and it will take several minutes and eventually time out. The same applies for staging. If you need to have more than 1,000 child nodes in most cases there is a way to split the tree into few more, separate sub-trees.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.