Re: comparing Oracle and mysql

"Pino Gargiulo" <jk3380_at_naida.org> wrote in message news:93npjj$coh$1_at_fe1.cs.interbusiness.it...
> Hello gurus,
>
> Please don't hate me for my next questions! I'm a novice Oracle DBA still
> working with
> 7.3; I carefully studied the Administrators Guide, Server SQL Reference
 and
> am almost
> through with the Tuning manual, so I feel quite confortable with Oracle.
>
> This afternoon my boss came to me with the news that I'll be working on a
> new
> e-commerce project for a major multinational that will be based on mysql .
 I
> questioned
> why use mysql instead of Oracle and the answer simple was 'The customer
> decided".
> I came up with some initial reason to avoid this solution, mainly non
> existant
> transactions, unreliability under high loads, no support for nested
 selects.
> Now I've
> got a new task: demostrate that Oracle is better than mysql! Why don't I
> learn to
> shut up!!!!.
>
> I've done some surfing and came up with some comparisons between mysql and
> Postgres
> but not much with Oracle.
>
> Anybody has something handy I can use_
>
> TIA to all
>
> /PG
>
>

They must be mad. First of all to force you to work with a desupported version of Oracle, secondly to replace Oracle by a toy. Question (provided we are not discussing continuing your museum software): does MySql has native Java support in the server? Answer: well of course not!
Question : does MySql allow you to perform online hot backup, which is mandatory for a 7x24 application like e-commerce? Answer: well of course not!
Question : does MySql has bind variables in order to avoid unnecessary statement parses? I've never seen it.

Why do these people even consider to run a mission-critical application with such a database? If they know anything about databases, they know they are starting on one of the safest routes to HELL. This is simply penny-wise and pound-foolish. You will be involved 7x24 hours to resolve ongoing problems and as they don't pay you a dime extra for it, they will simply not see those costs.

Advice to you: if they ignore your comments, quit that jon as soon as possible, before the train you are on actually reaches the abyss.

Regards,

Sybrand Bakker, Oracle DBA Received on Fri Jan 12 2001 - 15:20:37 CST