Hi! Look at the InnoDB/MySQL user stories at http://www.innodb.com
1200 queries per second on a single processor Intel box is easy to attain. A terabyte of data is handled at an InnoDB/MySQL site. InnoDB is close to Oracle in architecture. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ >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 $.02Thank you, Todd Williamsen, MCSEhome: 847.265.4692 >Cell: 847.867.9427 > >-----Original Message----- >From: Philip Mak [mailto:[EMAIL PROTECTED]] >Sent: Friday, November 30, 2001 9:59 PMTo: MySQL Mailing List >Subject: MySQL v.s. OracleHi 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