Re: Oracle vs MySql Performance

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

.

Relevant Pages

  • ORA-01092: ORACLE instance terminated. Disconnection forced
    ... I know that Oracle recommends AUTO, but I just want to test ... SQL> CREATE TABLESPACE "RBS01" ... Database mounted. ... SQL> CREATE ROLLBACK SEGMENT rollback1 TABLESPACE rbs01 ...
    (comp.databases.oracle.server)
  • Re: Can databases form automatic calculations?
    ... Basically I would like to know if there is some way to get a database ... All my product sales are ... Anyone know the MySQL function syntax for this if it is possible? ... The user interface is the SQL language which can be invoked ...
    (comp.databases)
  • Re: Anleitung für Oracle Upgrdae?
    ... To upgrade Oracle databases from a previous release directly to Oracle9i ... For more information about upgrading a database, ... For RAC installations, ensure that there is at least 50 MB of free space ... SQL> SHOW PARAMETER PFILE; ...
    (de.comp.datenbanken.misc)
  • Re: Oracle vs MySql Performance
    ... Performance on MySql was adequate but as our primary DB platform is ... Oracle we influenced the 3rd part to introduce an Oracle version (NB: ... To facilitate this process the vendor has used almost pure ANSI Sql so ... Look at the wait events in the raw trace file for clues ...
    (comp.databases.oracle.server)
  • DBConvert for MS SQL & MySQL 2.1.0
    ... DBConvert for MS SQL & MySQL is a database migration tool for data ... MySQL server directly. ...
    (comp.software.shareware.announce)