Database Design (MySql) :: should I put html data in a text field inside a database table or is it more efficient to save it inside a text.txt file?

We are building a large web application, and we are using mysql, we want to make the mysql database faster. Some of us think that if we put the html body message inside the table, and not inside text.txt, we will make the database heavy and not fast. Thank,

* Part of the main table containing the message: option 1: save the body of the html message inside the database

message {
id (int)
subject (varchar)
body (text)
}

option 2: hold the body of the html message inside the body1.txt file

message {
id (int)
subject (varchar)
file_body_path (varchar)
}

*

+3
source share
2 answers

If you:

  • ( , ..).

.

HTTP , .

+2

Quassnoi, -, , , ...

: , - - / TXT .

:

  • .

TXT " ". ?

+1

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


All Articles