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.
Thanks.
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
