I would appreciate any thoughts on the question below. Thanks.
I need to create a database for a document/note/message management system, in which there are upto 10 million users, and each generates upto 50 docs/notes/messages per day. ( similar to an email management system).
- On one end, a simple way is to have one table for user, and another huge table for docs. I am afraid that this may be slow as the table gets bigger.
- The other end, is to have one table per each user, resulting in many many tables, but the operations (select/update/insert) may be much faster.
Which would be more appropriate choice? In my system, users don't share documents (just as email users don't share their emails). Any thoughts/opinions would be of great help. Thanks