Mysql: text with json_encode or heap columns in the table — which is better?

Good day
What to choose? text with json_encode or a bunch of columns in a table?
For this data search is not needed.
Thanks for the replies.
July 5th 19 at 00:00
3 answers
July 5th 19 at 00:02
text with json_encode
and there is validity or something in this spirit? - Josiane75 commented on July 5th 19 at 00:05
Faster sampling if you are prompted for one field instead of 5 - Tyreek.Stoke commented on July 5th 19 at 00:08
: well, gather up 50 of them.. - Josiane75 commented on July 5th 19 at 00:11
what is the best for the trip - one suitcase with all my things, or suitcase for every thing, provided that during the flights of these things you do not need? - rickey_Swift commented on July 5th 19 at 00:14
: hmm... - Josiane75 commented on July 5th 19 at 00:17
the more json if you need 50 - Tyreek.Stoke commented on July 5th 19 at 00:20
: the ideal solution for you PostgreSQL the search in JSON or later muscule in which it is - Tyreek.Stoke commented on July 5th 19 at 00:23
: and don't happen to know how the current situation(in addition to XS Skok tables it is divided) may be in the running code is all correct? well to bikes. Before ROS functionality, increased number of users and the host is now looking at the load and not very happy. - Josiane75 commented on July 5th 19 at 00:26
: while armed only with mysql but if there is a speed boost through a virtual environment can all Docker to build? - Josiane75 commented on July 5th 19 at 00:29
: No Docker for another, you need a VDS. How much you pay for hosting? - Tyreek.Stoke commented on July 5th 19 at 00:32
: ~100 RUB/day - Josiane75 commented on July 5th 19 at 00:35
: 1000 per month take normal VDS do you have any of those features hosting Space / RAM / CPU ? - Tyreek.Stoke commented on July 5th 19 at 00:38
: me +/- the price is satisfied because the quality was checked host. But for other DBS, I'm not ready to move somewhere.. - Josiane75 commented on July 5th 19 at 00:41
: So is VDS the other database it is necessary to put and can be difficulties moving a serious, not so simple - Tyreek.Stoke commented on July 5th 19 at 00:44
: optimism, doing so is a no... - Josiane75 commented on July 5th 19 at 00:47
July 5th 19 at 00:04
Ideally, a separate table of key-value, but we do not live in a perfect world )
July 5th 19 at 00:06
Well, actually the database was invented to store data, and is not intended to store data in the data
If you don't have to search/sort by that parameter you can put in text
But increasing the flow of data between the database and the script and the script will need to write encoder/decoder JSON, if it suits You then why not.
use php.. and there's nothing "super" no - Josiane75 commented on July 5th 19 at 00:09

Find more questions by tags MySQL