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:scott@stripped]
> 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
> Scott Haneda Tel: 415.898.2602
> http://www.newgeo.com Fax: 313.557.5052
> scott@stripped Novato, CA U.S.A.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: