Hi!
>>>>> "Richard" == Richard Spangenberg <[EMAIL PROTECTED]> writes: Richard> I don't mean to start an opinion war, but ... Richard> Can mySQL handle many processors, many servers (clustering), load Richard> ballancing, etc as well as Oracle. Or should one use Oracle (some other Richard> database) for large volume high response requirements. Is mySQL too basic Richard> for these capabilities? It depends on what your application is doing and the type of queries. In some cases MySQL is much faster than Oracle, and in some other cases Oracle is faster. I don't know all details about Oracle, but I do know that MySQL can: - Use many CPU's efficiently (MySQL can however not split one query over many cpus) - Has a very efficient replication scheme which can be used to distribute load over many machines. - Use different table types to let you trade between speed or safety. Some benchmarks against Oracle: http://www.mysql.com/news/article-91.html http://www.mysql.com/information/benchmarks.html In other words, there is no easy answer; To know, you have to set up a test system and run tests. Richard> Pros and Cons, please. This should help settle an internal debate that is Richard> raging! Oracle has more features than MySQL (especially if you can afford to spend money to buy some of the Oracle add-ons), but if the MySQL feature set is enough for your application, MySQL should be a safe choice for you. As there is no licenses involved, I would recommend you to set up MySQL on your server and test it out! Richard> Rick Richard> ------------------------------ Richard> Richard Spangenberg Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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
