List:General Discussion« Previous MessageNext Message »
From:Kent Vilhelmsen Date:August 16 2002 1:43pm
Subject:RE: MySQL vs. Oracle (not speed)
View as plain text  
We've been using Oracle, Sybase, MS SQL, DB2 and even other databases in
our company, and we've decided to go with - mainly - MySQL. We didn't
really have a hard time convincing the management about this decision,
since we produced a whole "Open Source"-strategy at the same time,
giving some design principles that gives us as much flexibility and
scalability as possible. 

One of these, regarding databases, is that we want to minimize the use
of stored procedures. Stored procedures are of course nice in many cases
- they save network traffic, speed up queries, eases the application
programmers tasks and so on; but they are certainly not flexible in that
you can easily change your database vendor without having to rewrite
your code. Therefore, since flexibility means most to us, we've chosen
to move as much of the logic as possible up to the layers above the
database (for example, in ejbs). Oracle is of course brilliant for
banking, finance, government databases etc. - but probably waste of
money for web-portals, e-commerce and so on. 

The result is that it's easy to swap any components in the platform that
we're not satisfied with, for example the database. Also, we see that
MySQL delivers most of the functionality we want, including hot-backups
(using InnoDB), fulltext searches and foreign keys. Armed with systems
like linux, jBoss, Resin, ant, junit, xdoclet, middlegen, apache, perl
and many more, I believe our platform is about as good as it can be. 

We are of course lucky NOT to have top-managers who think they know more
about technology than the tech-department ;-)

Regards, Kent Vilhelmsen
Head of Systems Architecture
Eniro/Scandinavia Online








On Fri, 2002-08-16 at 15:07, Mary Stickney wrote:
> 
> It doesn't suport alot of differnt things....
> it dosent have store procedures , dosent have a complete SQL command set...
> 
> I am using it becasue I am being forced to...
> 
> 
> 
> -----Original Message-----
> From: Elizabeth Bogner [mailto:elizabeth.bogner@stripped]
> Sent: Thursday, August 15, 2002 9: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-mary.stickney=tagtmi.com@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-thread117305@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-kentv=a.sol.no@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- 
---------------------------------------------------------------
|  /   /                 Kent Vilhelmsen
| /   /    Head of System Architecture  Scandinavia Online
|/\  /   mob +47 40213917 desk +47 22583917 off +47 22583800 
/  \/    *  Standardise your content to fit ALL browsers!  * 
---------------------------------------------------------------
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