Hi! ----- Original Message ----- From: ""John Griffin"" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 10:25 PM > To: [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
