and a little bit messy -LW
|
|
|
|
good chemistry is complicated, and a little bit messy -LW |
|
| PerlMonks |
Answer: MySQL: BLOB/TEXT vs multiple VARCHAR columns |
| ( #36769=categorized answer: print w/ replies, xml ) | Need Help?? |
|
Q&A > database programming > MySQL: BLOB/TEXT vs multiple VARCHAR columns contributed by lachoy
Unlike many database systems out there, the overhead for BLOB/TEXT fields in MySQL (I normally just use TEXT) is practically none. Other databases (Sybase, IME) allocate at minimum a 2kb page for each TEXT field in a table, even if the TEXT field is empty. Eeek!
|
|
||||||||||||||||||