List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:April 18 2007 3:12am
Subject:Re: Problem on millions of records in one table?
View as plain text  
In the last episode (Apr 18), He, Ming Xin PSE NKG said:
> The number of the records in one table increase constantly. As
> evaluated, the amount would increase to at least 30 millions within
> one year.  So we worry about whether mysql could handle such a big
> amount of records with good performance. Or need we some other
> solutions to avoid this problem ,such as using Partition, dividing a
> big table and etc. Any help or idea would be greatly appreciated.

30 million records is not a problem, assuming you have enough memory
and disk.  You may still want to condider partitioning, if only to make
deletion of old data easier.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Problem on millions of records in one table?Ming Xin PSE NKG He18 Apr
  • Re: Problem on millions of records in one table?Dan Nelson18 Apr
  • Re: Problem on millions of records in one table?Brent Baisley18 Apr
    • Re: Problem on millions of records in one table?Jay Pipes18 Apr
      • RE: Problem on millions of records in one table?Ming Xin PSE NKG He19 Apr
        • Re: Problem on millions of records in one table?Jay Pipes19 Apr
    • RE: Problem on millions of records in one table?Ming Xin PSE NKG He19 Apr