Hi, I need to store text entries and i use text datatype. I want to ask if it will be better to split text and entry information? I mean, i can use a table like, (id, authorid, insertdate, editdate, threadid, textdata) or i can have an entrytexts table (id, entryid, textdata) and a foreign key on entryid -> entries.id. Which would be better? I might need to do some range searches and orders on entries so i thought splitting text might decrease some overhead? Or shall i just use one table? Thanks.
