Man 3 times same thread ! What I could consider to you, I don't really understand what you are getting at, what is wrong with 1000 users firstly ? And in the entry table store their userID which is stored in a session when they login ? So when they enter in data it stores their userID into a column , is that right ?
userID = autoinc userID in the user table > -----Original Message----- > From: Scott Haneda [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 11, 2004 2:50 PM > To: MySql > Subject: Database design.. Asking again > > > Sorry for the post again, I hijacked a thread and wanted to get > this on the > correct track. > > I can not seem to find the section in the manual that talks about the max > number of tables MySql can use, can someone point me please? > > I have been asked to build a database which could have some potentially > interesting storage needs. > > There will be a users table, there can be x users, if all goes > well, x will > be 1000's. > > Each user will be able to upload any number of records, with 100,000 being > the most. Average would be about 10,000 records, but I want to > plan this as > if average was 70,000. > > The 70,000 records will have the following structure: > Id, first name, last name > > So the table will be relatively meager in its storage needs. > Lets call this > table user_contacts. > > If users become day 1000 and each of those users has 70,000 user_contacts, > that would be 70,000 * 1000 total records in one table, as users > grow, this > becomes perhaps too many records in one table. Or at least the potential > for it. > > My next option would be to make a new table, user_contact-userid and make > one for each user, would would then mean, rather than one table with a lot > of records in it, there would be many tables with a max of 100,000 records > in it. > > Can someone share with me their thoughts and suggestions on this? > > > If anyone thinks I should just allow one table to store all this, > with that > table having 70 million records in it, then I can of course go > that road as > well. > -- > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
