Welcome to WebmasterWorld Guest from 18.104.22.168 , register , free tools , login , search , subscribe , help , library , announcements , recent posts , open posts Subscribe to WebmasterWorld
table structure - too many columns? meee msg:4091764 10:40 pm on Mar 4, 2010 (gmt 0) 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 msg:4091767 10:48 pm on Mar 4, 2010 (gmt 0)
How often will you be reading each field? I might put rarely-read fields in another table.