MySQL is very different in from Oracle-type databases in the way it is
marketed, supported, and licenced. It is more affordable, and much
better supported, as all of us know very well. Unfortunately, there are
many executives and developers that still do not trust MySQL, because of
some missing features, the need for workarounds, etc. To overcome this
prejudice while helping Monty and the bunch improve MySQL I am proposing
a contest - Oracle vs MySQL. Here is the rough outline of the rules:
- You find something that Oracle does well, lets say a query or a
sequence of queries, and document the performance in such a way that
everyone would know what needs to be done and how fast, then post it.
Tweaking Oracle to maximize performance is OK.
- All of us who are interested try to beat it or at least come close to
it on MySQL using comparable hardware cofiguration. Tweaking MySQL is
OK, including source modification, as long as your version passes the
crash-me tests. The winner gets some kind of a prize, maybe just public
recognition, or maybe if his solution allowed you to replace Oracle with
MySQL, a portion of the cost difference of Oracle and MySQL licencing
and support.
As I said, this is just a rough outline. Feel free to add your own
suggestions.
--
Sasha Pachev
http://www.sashanet.com
