|
MySQL optimization people, lend me your ears!
Alright, I'm doing up a database for a new project and would like to hear your opinion on something.
It's a member base site.... where they enter stuff into the db. No biggy there. Now, is there any benefits other than what's listed below to having each user have their own table?
In other words, instead of having a table that has ALL entries and a "userid" field to index by, is it worth having individual tables for each user: "entries_1", "entries_2", "entries_3" and so on?
The benefits I can see off hand are that if a user's table becomes corrupted or locked or what have you... it won't affect the other users.
The thing that makes me wonder is... would it have any impact on performance? Is it faster to have user's info separated so that there's less "searching" through records or is it slower to have a larger volume of tables to have to reference?
Thoughts?
|