In general, what's the advantage of separating the user login information and other other information into too tables? Thanks a lot
a*i
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
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
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.