Hello comunity,

I have a website that a lot of content and picture that has a shopping structure like this:

Product Archives

1. Product A
2. Product A
3. Product B
4. Product C
5. Product D

Product Categories

1. Category 1
2. Category 2

I have a multi node tree picker in Product type. So a product may in more than one category

The problem is that my query seem to be very very slow every we query in a category to search all product that concern to the category people in

This is how I work:

var baseShop = Umbraco.TypedContent(14147).Descendants("product"); // I get all the product I have and then filter below:
var listProduct = baseShop.Where(x => x.GetPropertyValue<IEnumerable<IPublishedContent>>("productCategories").Any(y => y.Id == Model.Content.Id)); // Model.Content.Id is the current categogy page user visit

But the page seem to be very slow, I have no idea what I should do to improve page load time.

• I understand that the main problem in the code like get listProduct. I think should query all the product that have relation by the category node. But I dont know how I can do. It's not like the database relationship I worked before.

My english is not good but hope that I have some idea to solve this problem