I would like to know one thing... How to make MySQL work with Oracle and viceversa!
I'm tired of the treads that reduce technology in cases of one or another... Cheers, Luis Ferro PS- What is the better tool a sand hammer or a nail hammer? answer: depend on what you want to pound! -----Original Message----- From: Robert Sundstrvm [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 13 de Dezembro de 2001 11:55 To: [EMAIL PROTECTED] Subject: RE: MySQL v.s. Oracle At 04:23 2001-12-02 , you wrote: >Not sure that total users is a good metric; queries per second may be >better. > >We host web sites and use MySQL with MyISAM tables for small and >medium-sized sites, Oracle for the big ones. Oracle's row-level locking >abilities make a big, deciding difference for the bigger, more active sites. >Oracle just scales much better than MySQL. > >Big downside of Oracle is the price, which is why we use it for just the big >boys. Costs too much to install on all our servers. > >I'm currently evaluating Berkeley and InnoDB tables to see how they compare >to Oracle. If they compare well then we may be using'em in place of Oracle >for most sites. I have done some admittedly not-so-scientific testing on MySQL (both with MyISAM and InnoDB) to find that both combinations performs best in single user systems. The test I run made about 50% updates/inserts and about 50% queries, with medium sized transactions (3-5 statements per transaction, where transactions was supported). On my regular desktop box I was able to get about 700 statements per second using MyISAM and about two thirds of that using InnoDB. Already at 2 simultaneous users (doing the same transactions) total throughput was less than for the single user case. Most stable commercial products exposes the opposite behavior. It may be the case that MySQL performs pretty well in single (or few) user cases, but the commercial alternatives will, in my experience, in most cases beat MySQL on 3-5 users and above. It is also the case that most commercial products supports better optimization methods than MySQL. Two important things are caching statement compilations at the server and stored procedures. If I have a performance problem in my database it is often the case that I can improve things by putting some SQL-code in a stored procedure. --------------------------------------------------------------------- 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