RE: MySQL versus Oracle

Also depends what you are doing. The first person to do a read causes a TABLE LOCK. No row level locking. MySQL way to assure the data you see back is what it really is.

But MySQL does have one nifty little feature, you can load tables into memory exclusively. Great for speed, terrible for recovery. But at least you don't have to issue a truncate, just kill the database, it does it for you.

Jon

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

If there's only one user accessing it, yes.

--Walt

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

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: wweaver_at_rightnow.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: Jon Baker
  INET: jcb_at_netsec.net

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).