Hello, I want to implement facet search on mysql. In fact it is a column with filters which is very often used to filter the products in the online store. For example in Magento
The data itself is stored in the form of "the product ID" "ID" attribute the "ID filter"
To implement this thing, a number of questions.
1) how to count the number of the filter? In the me example, the link indicates the quantity of items with the specified filters.
2)How best to store it in the table themselves filters if more than one attribute? Separated by commas or each filter in a separate row?
3)Will there be a significant increase when using MEMORY tables if you expect 300K records?
p.s. To make it clearer the attribute is a filter group, the filter is the value by which the filtered
p.s.s I'd love to do it on php mysql without using third-party frameworks.