AFAIK on big thing 'missing' in mySQL is that it
has no journalling (transaction logging) capabilities.
So there's no transaction mgt.. rollbacks...etc..
if things bozo in the middle of a process.. you're dead.
Restore from last backup and hope for the best.
So you wouldn't want to use it for storing
data that's really 'important'.
Lots of web sites use it to manage connection states etc..
where if it crashes.. well. they just restart.
I don't know if it handles replication.. or how well it would
digest 10 GB of data !
I think the open source 'postgres' [sic ?] database is supposed
to be more robust... It's now being supported and packaged by
the Red Hat Linux people.
In the long run, you get what you pay for !
-----Original Message-----
Sent: Wednesday, August 01, 2001 11:48 AM
To: Multiple recipients of list ORACLE-L
The comparisons look good for MySQL...
not bad for others, but better for
mySQL than some comments by some
folks on the list would have led me
to believe.
Anyone here have major gripes about
mySQL that oracle solved?
-----Original Message-----
Sent: Wednesday, August 01, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L
Interesting site...
Since I am not familiar with some of the other databases, are all the ones
listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions
old.
> -----Original Message-----
> From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 01, 2001 9:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: off topic--oracle Vs ms sql
>
>
> Try this site...
>
> http://www.mysql.com/information/crash-me.php
>
> On Mon, 30 Jul 2001 13:29:28 -0800
> "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote:
>
> > Does anyone have any doc or links that compares oracle and ms sql.
> >
> > Also what are the equivalent data types in ms sql for oracle's lobs.
> >
> > Thanks
> > Ravindra
>
>
> __________________________________________________________________
> Dwayne Cox
> DBA, Development Dept.
> Info Tech, Inc.
> [EMAIL PROTECTED]
> http://www.infotechfl.com
> ___________________________________________________________________
> The opinions expressed are the author's own unless otherwise stated
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dwayne Cox
> 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: Page, Bruce
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: Mohan, Ross
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: Farnsworth, Dave
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).