List:General Discussion« Previous MessageNext Message »
From:sasha Date:August 31 1999 4:15pm
Subject:Re: MySQL Speed ?? slower the Oracle ?
View as plain text  
Michael Widenius wrote:
> 
> >>>>> "Ben-Nes" == Ben-Nes Michael <miki@stripped> writes:
> 
> Ben-Nes> True but 2000$ don't scare big company's
> 
> I assume this is per user;  Big companies has many employees;  This means
> that $2000 will be a LOT for big companies if they want to let a major
> part of their employees access the database.
> 
> Don't forget $200,000 / year on support :)
> 
> We have done some speed checking of MySQL against Oracle; If you are
> working with the subset of SQL that MySQL supports, MySQL is usually
> MUCH faster (10-20 times faster).  On the other hand if you are using
> a query with many sub selects that can't easily be converted to normal
> joins and left joins or if you have to do a query in many steps in
> MySQL (with some processing in the client) and in one step in Oracle,
> Oracle will probable by faster.
> 
> I have heard many claims (and I really think it's true) that Oracle is
> good at big tables;  The problem is that we haven't been able to
> verify this with our benchmarks; According to these, MySQL scales much
> better when the file size gets bigger!  We hope to someday find
> someone that can optimize the benchmarks for Oracle so that we can get
> benchmark times for Oracle down to acceptable results.
> (The big problem with Oracle seams to be that you REALLY must get to
> know Oracle before you can get any performance out of it)
> 
> I think that Oracles strength lies more in reliability and capacity to
> handle MANY users (with mixed reader/writes) than in fast queries.
> (MySQL can also handle MANY users. It's only when you mix many slow queries
> with writes and can't let the readers wait as MySQL will not perform as
> good as Oracle)
> 
> Regards,
> Monty
> 

Now would you ever see an honest analysis of strength and weakness of
Oracle from an Oracle developer on a public mailing list? He will
probably get fired if he does it :-)

-- 
Sasha Pachev
http://www.freeservers.com
Thread
MySQL Speed ?? slower the Oracle ?Ben-Nes Michael31 Aug
  • Re: MySQL Speed ?? slower the Oracle ?Thimble Smith31 Aug
  • Re: MySQL Speed ?? slower the Oracle ?Paul DuBois31 Aug
    • Re: MySQL Speed ?? slower the Oracle ?Ben-Nes Michael31 Aug
    • Re: MySQL Speed ?? slower the Oracle ?info31 Aug
      • Re: MySQL Speed ?? slower the Oracle ?sinisa31 Aug
  • Re: MySQL Speed ?? slower the Oracle ?Ben-Nes Michael31 Aug
    • Re: MySQL Speed ?? slower the Oracle ?Michael Widenius31 Aug
      • Re: MySQL Speed ?? slower the Oracle ?Doug Salot1 Sep
        • Re: MySQL Speed ?? slower the Oracle ?Jules Bean1 Sep
          • Re: MySQL Speed ?? slower the Oracle ?James Rogers1 Sep
        • Re: MySQL Speed ?? slower the Oracle ?Jules Bean1 Sep
        • Re: MySQL Speed ?? slower the Oracle ?Michael Widenius1 Sep
  • Re: MySQL Speed ?? slower the Oracle ?Cary Collett31 Aug
  • Re: MySQL Speed ?? slower the Oracle ?Rick Moore31 Aug
    • Re: MySQL Speed ?? slower the Oracle ?Steve Ruby31 Aug
      • Re: MySQL Speed ?? slower the Oracle ?Jules Bean31 Aug
        • Re: MySQL Speed ?? slower the Oracle ?Michael Widenius31 Aug
      • Re: MySQL Speed ?? slower the Oracle ?sasha31 Aug
      • Re: MySQL Speed ?? slower the Oracle ?Jules Bean31 Aug
        • Job Available - Perl/MySQLArlen1 Sep
      • Re: MySQL Speed ?? slower the Oracle ?Michael Widenius31 Aug
      • Re: MySQL Speed ?? slower the Oracle ?Jules Bean1 Sep
      • Re: MySQL Speed ?? slower the Oracle ?Rick Moore1 Sep
      • Re: MySQL Speed ?? slower the Oracle ?Sasha Pachev6 Sep
    • Re: MySQL Speed ?? slower the Oracle ?Orlando Andico31 Aug
      • Re: MySQL Speed ?? slower the Oracle ?ed31 Aug
        • Re: MySQL Speed ?? slower the Oracle ?Cary Collett31 Aug
          • Re: MySQL Speed ?? slower the Oracle ?ed31 Aug
        • Re: MySQL Speed ?? slower the Oracle ?Orlando Andico31 Aug
          • Re: MySQL Speed ?? slower the Oracle ?Michael Widenius1 Sep
            • MySQL, GPL and RedHatMike Wexler1 Sep
              • Re: MySQL, GPL and RedHatThimble Smith1 Sep
              • MySQL, GPL and RedHatMichael Widenius1 Sep
    • Re: MySQL Speed ?? slower the Oracle ?James Manning31 Aug
      • Re: MySQL Speed ?? slower the Oracle ?Michael Widenius1 Sep
      • Re: MySQL Speed ?? slower the Oracle ?Ričardas Čepas1 Sep
  • Re: MySQL Speed ?? slower the Oracle ?Ben-Nes Michael31 Aug
  • Re: MySQL Speed ?? slower the Oracle ?sasha31 Aug
Re: MySQL Speed ?? slower the Oracle ?cmaurand1 Sep