Page 1 of 1
Large amounts of text in mysql
Posted: Tue Oct 19, 2004 7:18 pm
by meander
I have to post the text in a textarea to the dbase, so is it better to make a text field in the dbase, or have it written in a text file and then just put the link to the file in the dbase?
Posted: Tue Oct 19, 2004 8:24 pm
by kettle_drum
Depends on how much text there is take a look at the database manual to see how much data each field type can hold. Usually TEXT or BLOB are large enough - if there not, then you can save the text in a file, or maybe split it up in the database.
Posted: Tue Oct 19, 2004 9:30 pm
by meander
oh it wont be to big to fit in the dbase spot, i was wondering which way is more efficient...
Posted: Tue Oct 19, 2004 11:22 pm
by feyd
it's often just fine to use the database to store it in it's in entirity.. most, if not all databases will compress the "text" data automatically for you.