jordanwb Posted November 28, 2008 Share Posted November 28, 2008 I'm making a website for a friend who is a mortgage broker. He wants me to make an online application page and he showed me a list of fields he wants. There are literally at least 100 fields - about 12 are required (thank god for me), so I was wondering: Would having 100+ fields in a table would lead to any problems? Quote Link to comment https://forums.phpfreaks.com/topic/134668-solved-limit-to-ammount-of-fields-in-a-table/ Share on other sites More sharing options...
revraz Posted November 28, 2008 Share Posted November 28, 2008 Shouldn't, but you may be able to review the list and see if 100+ are really needed. Quote Link to comment https://forums.phpfreaks.com/topic/134668-solved-limit-to-ammount-of-fields-in-a-table/#findComment-701189 Share on other sites More sharing options...
jordanwb Posted November 28, 2008 Author Share Posted November 28, 2008 but you may be able to review the list and see if 100+ are really needed. I'm not really in the position to do that. It would make for one really long SQL statement. Quote Link to comment https://forums.phpfreaks.com/topic/134668-solved-limit-to-ammount-of-fields-in-a-table/#findComment-701192 Share on other sites More sharing options...
shlumph Posted November 28, 2008 Share Posted November 28, 2008 You could probably normalize it, breaking it these 100 fields into many tables instead of just one huge dump. Look for fields that can easily group together and put them in their own table. For more info: http://en.wikipedia.org/wiki/Database_normalization Quote Link to comment https://forums.phpfreaks.com/topic/134668-solved-limit-to-ammount-of-fields-in-a-table/#findComment-701197 Share on other sites More sharing options...
revraz Posted November 28, 2008 Share Posted November 28, 2008 Sure you are, you are the designer right? but you may be able to review the list and see if 100+ are really needed. I'm not really in the position to do that. Quote Link to comment https://forums.phpfreaks.com/topic/134668-solved-limit-to-ammount-of-fields-in-a-table/#findComment-701211 Share on other sites More sharing options...
jordanwb Posted November 28, 2008 Author Share Posted November 28, 2008 Sure you are, you are the designer right? Yes but I'm designing it as to how he wants it, and he wants those fields. Quote Link to comment https://forums.phpfreaks.com/topic/134668-solved-limit-to-ammount-of-fields-in-a-table/#findComment-701219 Share on other sites More sharing options...
Mchl Posted November 28, 2008 Share Posted November 28, 2008 There's such thing as vertical partitioning. You can split columns into two or more tables with one-to-one relation. Have frequently used columns and fields in one table, and rarely used columns in another. This will let you improve performance a little. Quote Link to comment https://forums.phpfreaks.com/topic/134668-solved-limit-to-ammount-of-fields-in-a-table/#findComment-701234 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.