Hi, if I have a web application which serve multiple users (corporate clients), each user company has its own list of individual accounts created, what is the best way to store this kind of accounts?
I would love to see comparison in terms of speed, maximum possible storage (no. of accounts in this case), and code maintainability/ upgradability.
- Create a new database for each new user company
- Separate all my tables with prefix like user1_accounts, user1_settings, user2_accounts, user2_settings, etc...
- Store all accounts from all companies in one table