I want to design a database for lots of users. Each user will be managing
their own messages. Does it make sense to create a table for each user after
they've registered?
Or should I just create one MESSAGES table and store messages there keyed off
of their user_id?
If I create a table for each user (I can potentially have hundreds of
thousands of users), will MySQL be able to handle this?
If I just have one table, I could potentially have millions of records in one
table. Will MySQL be able to handle this?
My gut feel is that MySQL will be fine with one table and millions of
records.
One table, with a user_id field. If you're worried about searching
through millions of records, perhaps you could have archival tables that
don't normally get searched and move messages from one to other after they
get "old"...
-p
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
