Re: Oracle vs MySql Performance

On Aug 21, 1:58 pm, Johne_uk <edg..._at_tiscali.co.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