List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:August 16 2002 1:42pm
Subject:Re: MySQL vs. Oracle (not speed)
View as plain text  
Hi!

----- Original Message -----
From: ""John Griffin"" <John.Griffin@stripped>
Newsgroups: mailing.database.mysql
Sent: Friday, August 16, 2002 3:29 PM
Subject: RE: MySQL vs. Oracle (not speed)


> Hi Elizabeth,
>
> The first question I would ask why don't you want Oracle? If you can't
come up with a good business reason why your >
...
MySQL also has what some people consider fairly serious drawbacks. MySQL
does not support triggers or foreign key constraints (yet) so data integrity
is always at risk. There is no equivalent of PL/SQL in MySQL, all database
procedures etc. must be written in a 3GL, such as C, and then linked in.
>

Fortunately InnoDB type tables in MySQL now support foreign key constraints.

Stored procedures in MySQL currently have to be replaced with programs in
the application or in the middle tier like the BEA WebLogic server or
Tomcat. MySQL AB staff is right now working on stored procedure
implementation, so they will come to MySQL in due time.

I tested a couple of days ago the MySQL-4.1 development tree. A simple
EXISTS subquery worked there. So there are already subqueries if you dare to
use the MySQL-4.1 development tree.

> If you feel your shop should become a MySQL shop I suggest you look at the
business reasons why and use those reasons to argue your case for you.
Technical coolness or altruistic support of the open source movement doesn't
cut it with most managers. Productivity, cost, and support usually does.
>
> John Griffin

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

> -----Original Message-----
> From: Elizabeth Bogner [mailto:elizabeth.bogner@stripped]
> Sent: Thursday, August 15, 2002 10:25 PM
> To: mysql@stripped
> Subject: MySQL vs. Oracle (not speed)
>
>
>
> A company I work with is in the process of upgrading its databases from
> some
> motheaten system to something current. My impression is that they
> want to go with Oracle, and I'm not sure if this is based on anything
> other than being impressed with the size and presumed quality support
> of Oracle. I'd like to encourage them to at least seriously consider
> using
> MySQL instead.
>
> I don't think that speed is a huge factor here; we do a lot of XML
> publishing
> and content management, but at most we'd have several gigabytes of
> data and several dozen simultaneous users, so well within the
> capabilities
> of MySQL. I've looked at various things I could find, like the benchmarks
> pages (probably not relevant) and the MySQL myths page, which was
> somewhat helpful, but I couldn't find anything more along the lines of
> "How to Convince my Management to go with MySQL." I don't even know
> what to expect from them, but I'm imagining they'll say, "But MySQL
> doesn't support sub-selects," to which I can reply, "But you can write
> most of those as joins anyway, so it won't matter because the software
> will all be written from scratch." Etc.
>
> Are there pointers anyone can give me?
>
> E. Bognewitz
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread117260@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-John.Griffin=pwgsc.gc.ca@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread117301@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-mysql=freebsd.csie.nctu.edu.tw@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
MySQL vs. Oracle (not speed)Elizabeth Bogner16 Aug
  • Re: MySQL vs. Oracle (not speed)Matthew Walker16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
    • RE: MySQL vs. Oracle (not speed)Kent Vilhelmsen16 Aug
    • RE: MySQL vs. Oracle (not speed)Francisco16 Aug
      • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
              • Re: MySQL vs. Oracle (not speed)Serge Paquin16 Aug
                • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                  • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
                • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                  • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                    • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                      • Re: MySQL vs. Oracle (not speed)Van16 Aug
                        • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • Re: MySQL vs. Oracle (not speed)Dan Nelson16 Aug
                        • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                      • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
        • RE: MySQL vs. Oracle (not speed)Francisco16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                • Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
                  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
                    • Re: improving slow query (was: MySQL vs. Oracle (not speed))Benjamin Pflugmann16 Aug
                • RE: MySQL vs. Oracle (not speed)Aron Pilhofer17 Aug
            • RE: MySQL vs. Oracle (not speed) - not part of the rant, but real informationAdam Nelson16 Aug
              • Re: MySQL vs. Oracle (not speed) - not part of the rant, but real informationDavid Lloyd17 Aug
        • Re: MySQL vs. Oracle (not speed)Tom Gao16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
              • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
            • Re: MySQL vs. Oracle (not speed)Mark Matthews16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
        • RE: MySQL vs. Oracle (not speed)Aron Pilhofer16 Aug
    • Re: MySQL vs. Oracle (not speed)Gelu Gogancea16 Aug
      • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
        • Re: MySQL vs. Oracle (not speed)Gelu Gogancea16 Aug
          • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
  • Re: MySQL vs. Oracle (not speed)Anderson Pereira Ataides16 Aug
RE: MySQL vs. Oracle (not speed)Art Fore16 Aug
RE: MySQL vs. Oracle (not speed)John Griffin16 Aug
  • Re: MySQL vs. Oracle (not speed)Elizabeth Bogner17 Aug
Re: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug
RE: MySQL vs. Oracle (not speed)Alec.Cawley16 Aug
RE: MySQL vs. Oracle (not speed)John Griffin16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney16 Aug
Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
Re: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug
RE: MySQL vs. Oracle (not speed)Kenneth Hylton16 Aug
Re: MySQL vs. Oracle (not speed)Jocelyn Fournier16 Aug
  • RE: MySQL vs. Oracle (not speed)Mary Stickney17 Aug
RE: MySQL vs. Oracle (not speed)Steve Orr16 Aug
RE: MySQL vs. Oracle (not speed)Heikki Tuuri16 Aug