Hi im about to start a project that will hopefully eventually hit milion+ users which is some kind of a site managment, problem is how to set the db in mysql, some people suggest way 1 and others way 2, i hope you can help me decide the right path to start.
needs to be stored:
- all users info:
user | pass | account status
path to compiled htm(in user folder with uid) | http request path | file seg1 | file seg2 | file seg3
personal settings (email..) | site settings (colors..) |
my ideas to store the data are:
path 1: have main db with table for usernames and passwords. create each user with db which inside have table for user files and table for user settings.
path 2: have main db for system which inside have: table for users and passwords and 2 more tables for each user: user_files, user_settings.
edit, add another path:
- path 3: 3 DB.. one for users\passwords second for user_files and third for user_settings that way it would separate the rows weight evenly between the user_files and user_settings. is that true?
And would a file system flat without the DB beside the user password is a better option here?