From: Dan Nelson
Date: April 18 2007 3:12am
Subject: Re: Problem on millions of records in one table?
List-Archive: http://lists.mysql.com/mysql/206231
Message-Id: <20070418031221.GC70813@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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