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. Quote Link to comment 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, Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.