We've a requirement where we need to build custom navigation solution and below is the site structured.
Products >> TV >> LG >> LG Accessories/setup >> Cable Type
>> Adapters
>> Speakers
Products >> TV >> SAMSUNG >> SAMSUNG Accessories >> How to fix
Products >> TV >> SONY >> SONY Accessories/setup >> Technical support
Cable Type, Adapters, Speakers are common across all type of TV categories and Navigation should have some design like this.
LG >> LG Accessories/setup >> Cable Type
>> Adapters
>> Speakers
SONY >> SONY Accessories >> >>Technical support
>> Cable Type
>> Adapters
>> Speakers
SAMSUNG >> SAMSUNG Accessories >> How to fix
>> Cable Type
>> Adapters
>> Speakers
So the content pages are created at one level, but for the navigation it will be scattered in different categories level. I know we can achieve this using tagging but it's becomes challenge with tags because we need to run multiple queries to get info at each category level which might be an issue with performance as well.
FYi, the above is just sample structure but we have 100s of pages from which navigation should be rendered.
Looking for inputs on the solutions which meets requirements as well as performance wise.
Thanks In advance.