>>>>> "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...