Skip navigation links

MySQL Forums :: MyISAM :: one big table or one million tables


Advanced Search

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

Hi,
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


Subject Views Written By Posted
one big table or one million tables 2611 Tudor Bastea 09/21/2011 07:22AM
Re: one big table or one million tables 1172 Rick James 09/22/2011 03:33PM
Re: one big table or one million tables 1999 James Day 10/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.