RE: MySQL versus Oracle

1. It's blindingly fast as a single user database, faster then oracle.

Really? Even with a 30 million record table?

-----Original Message-----
Sent: Friday, May 31, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L

I read few articles in Linux magazine and had it installed on my box for a while and here are my impressions:

1. It's blindingly fast as a single user database, faster then oracle.
2. It uses more or less standard SQL minus all the unnecessary functions like substr, decode, nvl and alike which nobody ever uses anyway (evil grin).
3. It's small. You can have both software and a small database within 150M
4. I didn't learn how to do recovery. It doesn't have hot backups. You have to shut it down to make a sensible backup.
5. It's easy to configure and doesn't have too many things to set up.

Allegedly, the present version (I did my dirty work back in August 2001) can use
Perl as a scripting language, I don't know whether DBI/DBD is needed for that and
it can cope with committs and rollbacks.

> -----Original Message-----
> From: Joe Testa [mailto:jtesta_at_dmc-it.com]
> Sent: Friday, May 31, 2002 10:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: MySQL versus Oracle
>
>
> Anyone on the list done a comparison(or worked with both) MySQL and
> Oracle and can give me the good/bad points of My SQL?
>
> Doing interviewer thing and someone has My SQL who would like to move
> into the oracle world and i know nothing about mySQL and am
> wondering if
> the transition from one to the other is easily done.
>
> thanks, joe
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> INET: jtesta_at_dmc-it.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: Gogala, Mladen
  INET: MGogala_at_oxhp.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: Ji, Richard
  INET: Richard.Ji_at_MobileSpring.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).