Re: Clash of the DBs in eWeek

On Thu, Feb 28, 2002 at 02:31:32PM -0800, Fisher, Julie wrote:
> And if you go to their web site www.mysql.com, they "crash me" compare
> against Oracle 8.1.6 and damn, they appear to look good. "They gots lots
> more green stars than Oracle, by george." Of course most of those
> categories are SQL functions/capabilities. They don't even touch on memory
> allocation, types of backups/archiving, so on and so forth. And of course
> the lack of column constraints,table constraints, foreign keys...<tsk> just
> noise. Wait!! Dammit Oracle!! Give me the tinyint type! MySQL has it!
>
> ...maybe I'm just being fussy....

Also, FYI, the performance comparisons at www.mysql.com are based on an *out of the box* Oracle configuration. No tuning at all. You can guess how well Oracle performs.

They have told me that they'd be happy to accept an updated comparison with a well tuned Oracle installation. Should be easy to do for someone here, they supply all the benchmark script and an automated harness for it.

Tim.

> Julie Fisher
> Sandia National Laboratories
> Oracle 8i DBA - OCP8i
> Solaris 2.6,7/HP-UX 11.0 System Administrator
> Web Server Administrator
>
>
> -----Original Message-----
> Sent: Thursday, February 28, 2002 2:24 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Also the article did not mention that in a lot of ways, MySQL is not nearly
> ready for prime time...
>
> MOYMMV
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Freeman, Robert
> INET: Robert_Freeman_at_csx.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fisher, Julie
> INET: jfishe_at_sandia.gov
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Bunce
  INET: Tim.Bunce_at_pobox.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).