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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
