Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle vs MySql Performance

Re: Oracle vs MySql Performance

From: EscVector <>
Date: Mon, 27 Aug 2007 18:09:10 -0000
Message-ID: <>

I'm working with DB Backed Jena that is native to MySql. Oracle and MySql are both installed on this linux box and also in Windows. While not by miles, Oracle does outperform MySql in every case. I have extensive tests charted in excel to show this. Since this is a 3rd party open-source app, there is little to optimize. The killer in jena is that it makes many thousands of calls to the database for very little return. The performance issue I see is not in the database, but that the app is doing tens of thousands of things very fast for very little return.

What I've found is that MySql runs slightly faster out of the box for un-indexed scans. But once indexed, Oracle bests MySql with as example a 3 second query dropping to one millisecond where as MySql was slightly less than one second with the index. It also highly depends on the MySql db format. InnoDB is very good out of the box.

The key, this is the environment were I work and every environment is singular, so don't expect the same results. They only way to know is to test.

On Aug 23, 3:19 pm, wrote:
> On Thu, 23 Aug 2007 10:49:57 -0700, wrote:
> >So, if you don't care about what MySQL does not have and don't care
> >about shutting
> >down database just to add a datafile, then, by all means use MySQL.
> >Oracle is the
> >wrong tool for you in this case. You get much better performance with
> >HW that
> >can handle twice the load
> The sad thing some people actually believe this drivel and run
> multiple user *production* databases using MySQL.
> Once this toy products falls on the floor and breaks, they will regret
> they didn't choose Oracle.
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Mon Aug 27 2007 - 13:09:10 CDT

Original text of this message