Just to help you along, why test 100m when you can test 1b SELECT FORMAT(count(*),0) as one_billion_rows FROM test2.test_size
>1,027,346,573 And so as we can see, mysql can handle pretty big tables. Rgds ----- Original Message ----- From: "Andrew Braithwaite" <[EMAIL PROTECTED]> To: "'Paul DuBois'" <[EMAIL PROTECTED]>; "'Andres Montiel'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, December 24, 2003 11:21 AM Subject: RE: 100,000,000 row limit? I don't believe this. I'm going to write a script to disprove this theory right now.. Cheers, Andrew -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday 23 December 2003 20:08 To: Andres Montiel; [EMAIL PROTECTED] Subject: Re: 100,000,000 row limit? At 0:57 -0500 12/23/03, Andres Montiel wrote: >I was informed that MySQL has a 100,000,000 row limit. Is this true? We >were planning to use MySQL for an inventory system. However, our >current data (rows) for 1 year for one area is already 8.8 million. We >want to place data for 5 years for 7 areas. This would exceed >100,000,000. Is there a possible work around for this? Where did you hear this? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]