I am building a theme for a local roofing company and we need to implement a solution for users to be able to search through custom posts and find what they're looking for based on custom field values.
For example, a user should be able to select that they are looking for all posts that match:
- roofColor = green
- roofType = shingles
- roofCity = chicago
There will be hundreds of projects (custom post entries) to search through. I'm interested in best practices here. Is it okay to be using custom fields for my custom posts in this example and to search for posts that have the matching custom field values? I have heard that the way wordpress stores values like this in the db would make it inefficient or slow, so I'm wondering if it would be better to build my own database to handle the special values for each roofing project?
Thank you for your time and insight, it's greatly appreciated!