Re: MySQL performance

[Martin Jacobson]

 
On Friday,  12, 2002, at 04:57PM, <dmorse@stripped> wrote:

>
>Rather than continue the debate about the efficacy of benchmarks versus
>real-world applications, I would like to examine MySQL's limited SQL
>support and how it impacts performance. These are areas where a
>full-featured Java DBMS can truly 'run rings around' MySQL in
>performance.
>

One of the main advantages of Java over other languages is 'platform-independence'. If the
underlying database supports the full SQL syntax, then the application can be ported from
one platform to another, and from one database to another without modification. I want to
be able to develop on my Macintosh running Mac OS X and mySQL, but deploy to my client's
Solaris/Oracle system without having to revisit my code.

The real issue with MySQL's lack of support for nested sub-SELECTs, and others, is that it
forces developers to 'code around' these problems.

In a world of mult-GHz processors, cheap memory, and fast disks, database performance is,
for the large majority of applications, of marginal importance.

Just my Eur 0,02!

Martin