How to store the characteristics of goods with the expectation of complex queries?

Question

MySQL

The database has 3 tables.
1 - products ( goods, for example: cars, houses, boats, etc. )
2 - products_features ( names of characteristics, for each type of goods different)
3 - products_veatures_value ( characteristic values ​​)
In this case, there are several problems:
1. Values ​​can be different types.
2. It is very resource-intensive to pull a product according to several characteristics.
What are the suggestions?

Answer 1

Carefully googling, I came to the conclusion that there are many ways to implement this idea. And each has its own strengths and weaknesses.
I also chose the option of storing data in one table,
According to the table for the type of product.
It's more concise here.
zlob.in/2013/01/struktura-tablic-dlya-kataloga-tov...

Answer 2

maybe it will suit habrahabr.ru/post/261137

Answer 3

store the goods prepared in the cache and scattered parameters on the tables for searching. no other choice