Can't resist... or 100 million rows won't run with a real db, like oracle, rather that the designers were thinking mysql when they built it...
Sorry ;) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, December 28, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: 100 million row limit (Part 2) "designed to work with" and "not compatible with anything over" are two /VERY/ different things. Yes, it performs very well on smaller tables...it also happens to work quite nicely on bloody huge ones. My computer's motherboard has a "designed for Windows XP" sticker on its box. That doesn't mean it won't run a real OS, like Linux, rather that the designers were thinking Windoze when they built it. ----- Original Message ----- From: "Andres Montiel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 28, 2003 6:43 PM Subject: 100 million row limit (Part 2) > I asked before regarding the supposed 100 million row limit of MySQL. The > said information was given to me by my colleague who has been using MSSQL > to develop applications. After asking him where he got the info., he gave > the follwoing URL: > http://dev-www.sqlwire.com/features/mssql/article.php/3087841 > > At the bottom of the article it quotes something from the MySQL > documentation: > "MySQL Server was designed from the start to work with medium size > databases (10-100 million rows, or about 100 MB per table) on small > computer systems." > The same quote can be seen in the MySQL Manual at > http://www.mysql.com/doc/en/Compatibility.html However, replies to my > previous email here on this list state that a number of databases have > more than 100 millior rows. Also, > http://www.mysql.com/doc/en/Table_size.html states that MySQL can indeed > go beyond 100 million rows. > > I'm confused. Why would the documentation discuss the 100 million row > limit if, apparently, MySQL can indeed go beyond this limit? Also, is > going beyond the 100 million row limit documented (aside from > http://www.mysql.com/doc/en/Table_size.html)? > > - Andres > > -- > 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]
