List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 1 1999 6:07am
Subject:Re: MySQL Speed ?? slower the Oracle ?
View as plain text  
>>>>> "James" == James Manning <jmm@stripped> writes:

>> BTW: Why isn't MySQL on the standard Red Hat distribution?
James> Lack of GPL licensing (the KDE/Qt exception is a long and difficult story)
James> and already shipping with PostgreSQL, which certainly looks more like a
James> "real" O-RDBMS... speaking of which, what's the performance gap between
James> the two?  Increasing?  Decreasing?  Neither?

Regarding MySQL and PostgreSQL: Neither is a complete or more 'real'
than the other; MySQL is more ANSI SQL if you just count 'features',
but PostgreSQL has some 'heavy' ANSI SQL features (like subselect and
transactions) that MYSQL doesn't have yet.

We haven't benchmarked the newest PostgreSQL release, so I can't
comment about the speed difference yet, but on the other hand we
expect MySQL 3.23 to be MUCH faster in some areas than MySQL 3.22.

When we last tested (With postgresSQL 6.4) MySQL was 4-20 times faster
than PostgresSQL on many common things and I don't think they have
been able to decrease that gap that much.

On the other hand, if you use some of the new features in MySQL 3.23
as in memory tables and the (new for 3.23.3) 'delayed_key_write'
option, you can get your applications magnitudes faster...

Regards,
Monty
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