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-----
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 5:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: MySQL versus Oracle
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
a) 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:
a) It's blindingly fast as a single user database, faster then oracle.
b) 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).
c) It's small. You can have both software and a small database within 150M
d) 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.
e) 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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
