MySQL is faster than any other database out there on small to medium sized web sites, but when you are going into larger sites, like yours, Oracle or MS SQL Server will be better suited for the task. Oracle does have one major draw back.... Price... For your size, you will spend in the neighborhood of $30,000+ for Oracle. You can try MySQL and see how it does, but I am sure it will hit its limits. In a situation like yours, you are best to be prepared, not unprepared. Oracle will do the job and then some.
If the price of Oracle scares you, what about load balancing the mySQL server into several web servers/database servers and making it into a server farm? One server will get the snot knocked out of it with that kind of load. Just my $.02 Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -----Original Message----- From: Philip Mak [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 9:59 PM To: MySQL Mailing List Subject: MySQL v.s. Oracle Hi all, We are currently using MySQL for our database driven website. Currently, we have about 100,000 users. In January, we will be getting 2 million new registered users on our website. We're buying a $50,000 Sun box to run the database server on. We're deciding whether we should switch to Oracle. Can MySQL handle this kind of load? The president (who doesn't know much about databases) was thinking about buying Oracle, but from what I've heard, Oracle is actually slower than MySQL since it needs to check FOREIGN KEYs, TRIGGERs, ASSERTIONs, etc. Can someone provide some advice? Thanks. My main concern is whether that massive scale (2 million registered users, along with all the data and CPU load they generate) is supported by MySQL. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php