UmbracoHelper.TypedContentAtRoot() extremely slow when U have a lot of child nodes

Questions
1

Hi Dear Everyone,

Please help with UmbracoHelper performance.

Short story:

  1. I have quite simple content structure:
    project->user->stuff

  2. While I have to identify project by some internal fields I did it like this:

    Umbraco.TypedContentAtRoot().Where(…

  3. Everything was perfect until the moment when in some project I got almost 2k child nodes (User type) and performance slowed almost to 100 times! (from ~100-200mc to 10-20seconds)

I played with structure and figured out that initializing Children isn’t lazy, and every time when I just need to get list of root nodes I’m getting the list of Initialized Children.

I fixed it by getting root nodes from (as U said - very slow and not preferable way for getting content) “ContentService” - it’s not that fast, but obviously faster what I have now.

P.S. I’m open with any kind of suggestions regarding possible ways to solve it in right way (not just changing structure - cause for me it’s normal situation when U have a lot of subNodes) or just ask Umbraco Core team to get Children lazy.

This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/77898-umbracohelpertypedcontentatroot-extremely-slow-when-u-have-a-lot-of-child-nodes