What is the best way to store JSON or MSQL attributes?

Question

MySQL

I have a need to store the attributes of a field in the database, how can I best implement this.
The first option is to store this data in the json field of the MSQL table as json, but there is a problem with records



. The second option is to scatter it across tables. Schema field_categories
fields field_attributes field_options The question is will this be more optimized in the long run?

Answer 1

So how do we know how often what requests need to be made.
For sampling by different fields, it is clear that it is more convenient to scatter over the fields or even a table to simplify indexing.
If you take out all the json by id, then it may be faster to store json