List:General Discussion« Previous MessageNext Message »
From:Aron Pilhofer Date:August 16 2002 2:24pm
Subject:RE: MySQL vs. Oracle (not speed)
View as plain text  
Not to open a can of worms here, Mary, but I'd love to know exactly how you
got those results, since they basically contradict every known benchmark I
have seen (at least those not funded by M$... this being one:
http://www.eweek.com/article2/0,3959,293,00.asp) as well as every
benchmarking test I have run myself.

My results, frankly, have not been close -- not even in the same ballpark.
So I suspect if you are getting different results it has something to do
with your configuration.

Just for the record: I'm not particularly anti-MS. I like Windows XP, I
think they make some decent software (Access and Excel are what I teach on
most often). And you do get a lot of nice features with SQL Server -- speed
just doesn't happen to be one of them.

Regards,

aron


> -----Original Message-----
> From: Mary Stickney [mailto:mary.stickney@stripped]
> Sent: Friday, August 16, 2002 9:53 AM
> To: Francisco; Elizabeth Bogner; mysql@stripped
> Subject: RE: MySQL vs. Oracle (not speed)
>
>
>
> I have been doing speed tests....  the same query ran on MYSQL took 45
> minutes
> on MS-SQL  it took 11 minutes......
>
> yes you do get what you pay for....
>
> -----Original Message-----
> From: Francisco [mailto:frsgti@stripped]
> Sent: Friday, August 16, 2002 8:47 AM
> To: Mary Stickney; Elizabeth Bogner; mysql@stripped
> Subject: RE: MySQL vs. Oracle (not speed)
>
>
> Hi,
>
> I am beging using MySQL for quite a while and it is a
> very good choice if you don't really need stored
> procedures. MySQL provides a pretty good
> implementation of a subset of MySQL-92, performance is
> great, it is cross-platform, provides transactions,
> and its price... well is free.
>
> Hope it helps.
> --- Mary Stickney <mary.stickney@stripped> 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-frsgti=yahoo.com@stripped>
> > Trouble unsubscribing? Try:
> > http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
>
>
> ---------------------------------------------------------------------
> 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-thread117315@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-aronpilhofer=yahoo.com@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