Database design (MySql)::should we put html data in text field inside database table or more efficie
Posted
by meyosef
on Stack Overflow
See other posts from Stack Overflow
or by meyosef
Published on 2010-05-25T10:01:41Z
Indexed on
2010/05/25
10:21 UTC
Read the original article
Hit count: 190
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)
}
*
© Stack Overflow or respective owner
