On May 14, 2007, at 4:37 PM, Bill Moseley wrote:
> Say that there's also about 10 columns of settings or preferences for
> each user. Are there any cases or reasons to have a separate
> "user_preferences" table vs. just placing all the columns together in
> one table?
when you have, say 65 million users, it makes sense to push the
ancillary info to another table to keep from having to copy too much
data when you update the main info (like last access time).