Re: Oracle vs MySql Performance

Johne_uk wrote:
> The phyiscal db structure (indexes etc.) was coverted as is from
> Mysql. The bulk of initial performance problems were removed by
> gathering stats on oracle.
>
> I guess we need to look at the issues from two plans of attack. First,
> look at optimisations for the oracle schema and second, take a look at
> the java layer and its interaction with Oracle.
Isn't mySQL just a front end for a storage engine. Unless I'm mistaken the capabilities (or lack thereof) of the storage engine contribute a lot to the performance. E.g. if mySQL was running in transactional mode it is no wonder it runs circles around a transactional DBMS (not limited to Oracle)

Cheers
Serge

PS-Sybrand: If ANSI SQL needs to be replaced by special purpose proprietary features in order to get _equivalent_ performance that IMHO is a problem. It means that a product doesn't perform without "tricks" (in contrast to performing "even better" with tricks - which is fine...). If that were truly the case, it would be what Daniel calls "a keeper".

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab