Hi guys,
I am trying to optimize the performance of a project that has a couple of characteristics:
1. Multiple websites, multiple shops
2. High number of categories and subcategories
3. High number of properties for filtering
The performance is affected by the number of Expressions in a query. At least that's the first thing that needs optimization.
In order to handle it, I have tried to reduce ythe number of queries and fields as much as possible. Then, I tried to separate the Queries for each Level 1 Category.
This approach would significantly decrease the number of Query Expressions and the number of facets for each Level 1 tree but I have a major problem with URLs.
My approach was to create a separate page for each Level 1 category, add ProductCatalog module on a paragraph and set Ecommerce navigation on each page. Then, turn on the new URL option to get clean URL structure.
Everything looks fine for the first Category but the links for any subsequent categories are getting a -1,-2 respectively at the end of the URL.
I guess the system sees every instance of the URL as a duplicate.
I see that the URL properties take into consideration the Shop and Language but there is no filter for the Parent Group.
Is this something that can be accomplished with a custom URL provider?
Is there any other approach for this type of segmentation?
Thank you,
Adrian