I have a project that requires structured search of a product set in the realm of 10,000 SKUs.
Users will be able to make a single pick from each of 3 <select> menus of options:
1. Manufacturer (list probably derived from a Manufacturers channel field)
2. Appliance model (list probably derived from a related Products channel field)
3. Part number type (list probably derived from a dedicated category group)
I want to be able to query 2 when the user selects from list 1, and to query 3 when the user selects from list 2 such that lists 2 and 3 only show options for which there are 1 or more results.
Obviously this will require an Ajax lookup.
If it’s not too vague a question, can anyone recommend querying and caching strategies to make sure that lists 2 and 3 are populated as swiftly as possible?
I have in mind to use Solspace Super Search to assist with this.
Thanks.