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: sybrandb <>
Date: Tue, 21 Aug 2007 05:26:57 -0700
Message-ID: <>

On Aug 21, 1:58 pm, Johne_uk <> wrote:
> Hi,
> I'm looking for a few opinions on an issue we are experiencing.
> My company currently uses a 3rd party application. Up until a few
> weeks ago this application consisted of Java code and a database layer
> that used MySql.
> Performance on MySql was adequate but as our primary DB platform is
> Oracle we influenced the 3rd part to introduce an Oracle version (NB:
> most of the sql code is stored in a java db layer - schema just
> consists of tables, views and indexes).
> To facilitate this process the vendor has used almost pure ANSI Sql so
> that the same sql can be used for both oracle / mysql with minimum
> conversion required.
> When the system was released we were surprised to find that the sql
> (and hence application) ran slower on oracle than MySql (the Oracle db
> server is also considerably more powerful).
> At a high level does this surprise anybody on this forum. Does Oracle
> struggle to execute ANSI sql compared to MySql.
> The orginal code was also written for MySql and converted so that
> might explain why is is running slower.
> Any thoughts would be appreciated.
> Tanks in advance
> John

Oracle compared to MySQL <--> Apples to Pears.

The architecture is completely different.

'Porting' Sqlserver, or MySQL to Oracle NEVER works!!!! If you read any book by Tom Kyte, you will know why. Set up a database agnostic app and you will notice you don't use the power of a database anymore, and you will primarily use it as an expensive replacement of a system running on punch cards.

Sybrand Bakker
Senior Oracle DBA
Received on Tue Aug 21 2007 - 07:26:57 CDT

Original text of this message