MySQL Forums
Forum List  »  MyISAM

one big table or one million tables
Posted by: Tudor Bastea
Date: September 21, 2011 07:22AM

We are developing an application that needs to store a lot of data, at this moment there are 350K new entries each month, but it is very possible to get to 1mil entries per month. Each new entry (row) belongs to a certain user, identified by a numeric value. We will need to select all the entries of a user, so at least one index is necessary, and create some reports based on those selects.

The other solution would be to create a table for every user (200K at this moment, but will probably reach 1mil soon). So there would be 200K - 1mil tables, each with the data of that specific user.

Which of these solutions is the best? Our server is CentOS, if this matters.

Options: ReplyQuote

Written By
one big table or one million tables
September 21, 2011 07:22AM
September 22, 2011 03:33PM
October 16, 2011 07:25AM

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.