Good practice? Storing data... json?

Question

PHP

RESOLVED.
Here is an example:

Answer 1

what for? In my opinion, this is the place to apply the relational principle of storage. I made a store, 100k goods, each with 30-50 parameters, everything flies. the integrity of the database does not need to be monitored by hand. and so you get a microsubd, some kind of your own index. this is a gemara and then the data will suddenly fall apart and will not be repaired quickly.
gyazo.com/e27e934b9bf1c2431a7fbf9db9c501f4 here is a diagram. products and properties belong to categories. property values ​​are hung out on their product links.
your version is also implemented. just for what?
In terms of speed, I can definitely tell you that all this works quickly. the load slightly increases depending on the number of parameters included in the request (checked boxes, sliders, etc.). it doesn’t depend on the number of goods at all, we tested for 600k