a***i
发帖数: 39 | 1 In general, what's the advantage of separating the user login information
and other other information into too tables?
Thanks a lot | a***i
发帖数: 39 | 2 怎么看不到回复？
【在 a***i 的大作中提到】
: In general, what's the advantage of separating the user login information
: and other other information into too tables?
: Thanks a lot
| a******z
发帖数: 280 | 3 感觉是速度上好一些，在DB管理上好一些
account is a frequently accessed table, if you have a lot user information
column, that's won't be that efficient.
and, account is account, user information is information, it is different
concept. one account [family account] may have several users' information.
this design will give more flexibility when you want to scale your system. | a***i
发帖数: 39 | 4 one more thing i can think of is if your website need to support multiple
properties, then definitely need to separate the login info from others.
thanks for the reply
【在 a******z 的大作中提到】
: 感觉是速度上好一些，在DB管理上好一些
: account is a frequently accessed table, if you have a lot user information
: column, that's won't be that efficient.
: and, account is account, user information is information, it is different
: concept. one account [family account] may have several users' information.
: this design will give more flexibility when you want to scale your system.
|
|
