Page 1 of 1

Users and user profiles

Posted: Sat Jul 08, 2006 3:37 pm
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

Posted: Sat Jul 08, 2006 3:45 pm
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.

Posted: Sat Jul 08, 2006 3:49 pm
by jivy
Thanks for the tip!

scott