RE: Problem on millions of records in one table?

2007-04-18 Thread He, Ming Xin PSE NKG
Hi, Pipes Is it reliable to use MySQL 5.1 in a commercial product now since it is still a beta version? -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 18, 2007 10:04 PM To: Brent Baisley Cc: He, Ming Xin PSE NKG; mysql@lists.mysql.com Subject: Re

RE: Problem on millions of records in one table?

2007-04-18 Thread He, Ming Xin PSE NKG
Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 18, 2007 9:37 PM To: He, Ming Xin PSE NKG; mysql@lists.mysql.com Subject: Re: Problem on millions of records in one table? It all depends on how complicated your data and searches are. I've got tables that ad

Problem on millions of records in one table?

2007-04-17 Thread He, Ming Xin PSE NKG
Hi,all 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 probl