From: Date: July 15 2002 9:31am
Subject: Re: MySQL performance
List-Archive: http://lists.mysql.com/java/4002
Message-Id: <5935320.1026718267066.JavaMail.martinjacobson@mac.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

 
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