Users and user profiles

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jivy
Forum Newbie
Posts: 2
Joined: Sat Jul 08, 2006 3:26 pm

Users and user profiles

Post by jivy »

When you have a database of users for a website, is it best to put all the profile/preference fields in the actual users table? Or would it be better to have a separate table altogether, with each user having a has-one relationship to it? If the latter, what kind of information should be reserved for the users table? This is my first project using Cake/MVC, so I am trying to do things more efficiently than I have in the past.

scott
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

jivy wrote:When you have a database of users for a website, is it best to put all the profile/preference fields in the actual users table?
That could depend on optimization needs, storage needs and so forth. In general, no, it rarely calls for a separate table.
jivy
Forum Newbie
Posts: 2
Joined: Sat Jul 08, 2006 3:26 pm

Post by jivy »

Thanks for the tip!

scott
Post Reply