acidglitter Posted August 16, 2008 Share Posted August 16, 2008 i'm making a new website, and for one of the tables almost all of the fields are ints and small varchars, then there's one text field. the text field won't be selected as much as the other fields. would it load faster to separate the text field from the others by using two different tables? so far the table is over a megabyte only because of the text field. Link to comment https://forums.phpfreaks.com/topic/119926-best-way-to-do-this/ Share on other sites More sharing options...
bluejay002 Posted August 16, 2008 Share Posted August 16, 2008 Well that depends on the data you were talking about. If it is necessary then let it be, if it is more convenient that way then let it be, but if you think there are other means to make it betterm then do it. Since your question is quite general, I could only give a general answer. The design may differ from one to other depending on the data being stored and their relationships. Normalization is good but do not overdo it as it may hurt back also; so for some instance, denormalization is pretty handy. Jay, Link to comment https://forums.phpfreaks.com/topic/119926-best-way-to-do-this/#findComment-617814 Share on other sites More sharing options...
fenway Posted August 17, 2008 Share Posted August 17, 2008 Just make sure you don't select "*" -- or include the TEXT field in any group-by / potential filesort operators -- and you'll be fine. Link to comment https://forums.phpfreaks.com/topic/119926-best-way-to-do-this/#findComment-618658 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.