@{ var site2 = Model.Root(); var attendeesByUser = site2.Descendants().Where(x => x.Member != null && x.Member.Id == currMemberId).OrderBy(x => x.StartDate); } My Events @foreach (var att in attendeesByUser) { My Events } This above code hits DB and reaches CPU 100%. Umbraco version : 11

Your Descendants call basically goes through all of your nodes on the website. You should try to avoid Descendants and go through your tree with Children of other methods

I'd suggest the .Member call may be the issue. Perhaps move it to after the MemberId check.

It will be the member call. Try it without and compare.

ok thanks. I will give a go and will update

If you've got so many records that this is trashing your DB, i'd use the search index to get the items you need.

Here is the tree structure - Events - Event Category 1 - Event 1 - Attendee - Attendee 1 ( Reference to Member) - Attendee 2 ( Reference to Member) - Event Category 2 - Event 1 - Attendee - Attendee 1 ( Reference to Member) - Attendee 2 ( Reference to Member) - Event Category 3 - Event 1 - Attendee - Attendee 1 ( Reference to Member) - Attendee 2 ( Reference to Member)