I have worked quite a lot with Oracle and a bit with MySQL (neither while dealing with Jackrabbit). Here are some of my observations:
1. As a non-DBA, MySQL is much easier to manage/maintain than Oracle. You will really need an experienced Oracle DBA to properly run Oracle. Since your organisation is moving towards Oracle in a big way, that angle should already be covered. 2. MySQL SQL 92 compliance is IMO better than Oracle. 3. Oracle does not support information_schema, since they have had their own data dictionaries. 4. Performance is a mixed bag. MySQL was faster for single table queries when table sizes are reasonable (< 2 million rows). Join queries were generally faster on Oracle. 5. Oracle query optimiser was much better IMO than MySQL. Complex queries with multiple filters almost always ran faster on Oracle (even for a single table query). 6. Result caching etc. once again better on Oracle 7. Oracle JDBC drivers have improved a lot, so that should no longer be an issue. They were quite frankly horrible when I was working with Oracle, until around 2002. We were using the DataDirect JDBC driver with Oracle due to limitations and bugs in the Oracle JDBC driver. A note related to performance. We were not comparing performance on identical hardware. Our tests were conducted with MySQL running on dual CPU 2 GHz Intel hardware (circa 2003/4), while Oracle was running on old 8 CPU 450 MHz Sun Hardware. Rakesh On 16/09/2010 13:09, "SeanMcTex" <[email protected]> wrote: Hi folks, Our institution is making a push toward using Oracle all over the place. We've been using MySQL as our substrate under the JCR for Magnolia for several years now, but are interested to know whether a move to Oracle would make our lives better or worse in any significant way. Has anybody had experience with both? If so, could you provide any insight you have on the relative merits of each? We're particularly interested in performance, maintenance, etc. Thanks for any insight. Sean -- View this message in context: http://old.nabble.com/Oracle-vs.-MySQL-tp29731384p29731384.html Sent from the Magnolia - User mailing list archive at Nabble.com. ---------------------------------------------------------------- For list details see http://www.magnolia-cms.com/home/community/mailing-lists.html To unsubscribe, E-mail to: <[email protected]> ---------------------------------------------------------------- ---------------------------------------------------------------- For list details see http://www.magnolia-cms.com/home/community/mailing-lists.html To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
