K
K
k-22016-07-27 14:18:51
MySQL
k-2, 2016-07-27 14:18:51

What is the best way to organize product parameter tables?

How would it be more correct and efficient to compile tables.
I take into account performance when searching by value_params_char
f7c65192368f47cabe912709c3b06c67.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
xmoonlight, 2016-07-27
@K-2

The first way + unique indexes on all id and name_params and on value_params_char.
But it's better to think about storing in JSON in mysql>=5.5 and somehow revise the current structure.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question