homepage Welcome to WebmasterWorld Guest from 54.226.180.223
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved