Welcome to WebmasterWorld Guest from 54.147.10.72

Forum Moderators: open

Message Too Old, No Replies

table structure - too many columns?

     

meee

10:40 pm on Mar 4, 2010 (gmt 0)

5+ Year Member



The below is my table structure. Do you think I should create 2 tables to have less columns in 1 table? I was thinking to separate registration related data (password, e-mail, dataofregistration, profileviews, ...) to another table. But does it make any difference at all since each field will have only 1 data?

userid | password | registrationemail | level_access | date_registered | temp_pass | active | profileviews | firstname | lastname | phone | address | city | postcode | country | birthday | currentstatus | currentcompany | image | academictitle | academicdegree | workingtitle | companyid | profilecompleted | description | twitter | facebook | www |

LifeinAsia

10:48 pm on Mar 4, 2010 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



How often will you be reading each field? I might put rarely-read fields in another table.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month