Re: Problem on millions of records in one table?

[Dan Nelson]

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