Welcome to WebmasterWorld Guest from 54.196.233.208

Forum Moderators: open

Message Too Old, No Replies

table structure - too many columns?

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

New User

5+ Year Member

joined:Dec 28, 2009
posts:12
votes: 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 |
10:48 pm on Mar 4, 2010 (gmt 0)

Moderator from US 

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

joined:Dec 10, 2005
posts:5550
votes: 24


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