I have a pressing issue I need some quick advice on from someone who understanding the wordpress database structure.
I am currently considering utilizing WordPress 3.0 to build a coplex real estate website.
For things to work correctly I need to make use of custom taxonomies and custom fields.
I have been told that its actually not a good idea to utilize custom taxonomies for things such as "number of bedrooms, bathrooms, ..." but instead to use custom fields for this.
A critical aspect of the design is the need for users to be able to search through hundreds of thousands of properties (posts) by defining specific search criteria such as any one/more of these examples: zipcode, bedrooms, bathrooms, square footage range, garage, pool, view,....
From my understanding, by default wordpress does not allow you to query more than one custom fields/taxonomy at a time but there are plugins which allow for this to take place.
I have been told that instead of utilizing custom taxonomies its best to use custom fields for these purposes and then to have mysql index the meta fields database column.
So, my question to all you experts is... what is the correct way of achieving my objective with minimal load and maximum functionality while ensuring things are still very fast when it comes to searching through all these properties (posts)?
Does anyone have any advice along with maybe an example of what you have done and what lessons you have learned to ensure I do things correctly from the start?
Thank you very much for your help in advance!