What would be faster when recovering data from mysql database?

What will be faster in getting data from mysql database? Is the data divided into two columns or the same data from one column?

Edit:

Just to give an idea, I have a table for the question and five answers that she will receive. These answers are quite large for approximately 1,500 words. When it comes to data search speed, should I use a column for each answer, or should I just make one column with 5 answers separated by a separator, then use a script to separate them?

+3
source share
6 answers

. , db ( ), re - .

, . . , , , . , , - . , .

+4

"" . 5 , .

, . , .

+4

, .

, .

.

+2

. , , .

+2

, , , , , .

, , , 3 :

CREATE TABLE answers (
  question_id INTEGER PRIMARY KEY,
  answer INTEGER,
  answer_text TEXT
);

- 1, 2, 3, 4,.. , .

+2

. , varchar, , , , , .

0

Source: https://habr.com/ru/post/1774373/


All Articles