Database design (MySql)::should we put html data in text field inside database table or more efficie
- by meyosef
Hi,
We building big Web Application and we use mysql, we want to make mysql database more fast.
Some of us think if we will put message html body inside table and not inside text.txt in will make database heavy and not fast.
Thanks,
*Part of main table that hold message:
option 1:hold html message body inside database
message {
id (int)
subject (varchar)
body (text)
}
option 2: hold html message body inside body1.txt file
message {
id (int)
subject (varchar)
file_body_path (varchar)
}
*
