Say I have information about accounts; account basic information and account extended information. The account information is used often due to profile searches, while the account profiles is only accessed when the user actually clicks on a profile. What’s more efficient?
1)One table with the account information along with the account profile
2)Two tables, one with basic account info, the other with extended account info, and then doing a join when needed?
- The topic ‘mySQL Efficiency?’ is closed to new replies.