I am going to have a web hosted MySQL database. It will hopefully have 100+ users. I was thinking of having one database to store all records for all users. I would store a user_id against records where appropriate to relate them to a particular user. The database will have a contacts table, users table, session_data table the contacts table will contain a field user_id to identify which contact is associated with which user. This will lead to a very large contacts table (million records???) Alternatively I could create a database for each user database_user1, database_user2 etc, each one of these databases could be then referenced dynamically in my application code, depending on the user logged in. Each one would have its own contacts table, specifically for that user.....
Which is the better way to go, in the opinion of any gurus out there..one very large database or multiple instances of user particular databases. Any guidance would be greatly appreciated. Regards Joe
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
