Timeline for big db for managing user files and settings
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 6, 2013 at 13:25 | vote | accept | Mike | ||
| Mar 20, 2013 at 13:24 | comment | added | mdoyle |
Each file gets a new record added to user_file table. There's no issue with multiple users having files recorded in the same table, because each record has the user's unique ID number in it.
|
|
| Mar 20, 2013 at 5:47 | comment | added | Mike | the userspasswods and userssettings i understand how to manage each in a table. i dont understand how to put all the users files in one table.. you will have for each user atleast 10 files. should i maybe make each user a table called "%userID%_files" and inside place the files of the user? | |
| Mar 19, 2013 at 14:56 | comment | added | mdoyle | That is not even close to following to the relational model. If you intend to implement this in MySQL, you certainly aren't going to want millions of tables, all but one of them with one record each. You shouldn't have any issue with the three tables in my answer, each having millions of records each. | |
| Mar 19, 2013 at 14:40 | comment | added | Mike | Yes each user needs a files table and a settings table | |
| Mar 19, 2013 at 13:51 | comment | added | mdoyle | Per-user tables? So adding a new user means adding two new tables? | |
| Mar 19, 2013 at 13:31 | comment | added | Mike | Its not 3 tables, its (2xUsersCount)+1 tables. Is it still preffered? | |
| Mar 19, 2013 at 13:14 | comment | added | mdoyle | Three separate databases? No, I wouldn't do that. I would just use the three tables above in a single database. | |
| Mar 19, 2013 at 4:48 | comment | added | Mike | thank you for your answer. i was suggested a third path which i think would split the db better. 3 DB.. one for users\passwords second for user_files third for user_settings that way it would separate the rows weight evenly between the user_files and user_settings. is that true? | |
| Mar 18, 2013 at 21:06 | history | answered | mdoyle | CC BY-SA 3.0 |