MySQL Forums
Forum List  »  Optimizer & Parser

Database structure question
Posted by: Bozhidar Bozhanov
Date: April 17, 2006 10:29AM

Hello.

A number of months ago I started a project, but then I did not realize the need of a good database structure, so I made that every user has his own table, named "{username}_products".

So, in this case, when 1000 users signup, I'll have ~1020 tables in my database.

Is this a SERIOUS problem, which I should immediately work on, or it is acceptable and does not lead to slow db operations, etc.

Options: ReplyQuote


Subject
Views
Written By
Posted
Database structure question
2634
April 17, 2006 10:29AM
1774
April 17, 2006 10:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.