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)
}
*
Yosef source
share