Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4BD0A70A.1030907@absinth.fi>
Date: Thu, 22 Apr 2010 22:44:10 +0300
From: Rami Ojares <rami.ojares@pdf-comics.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
 rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Re: performance: Derby vs H2
References: <j2s73a01bf21004220947s4069d0b6u21082c051759f277@mail.gmail.com>
In-Reply-To: <j2s73a01bf21004220947s4069d0b6u21082c051759f277@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I think the best authority on this is Thomas Mueller (father of h2) who 
has actually done some performance comparisons between databases.
I remember reading some debate about this on some discussion groups a 
year or two ago.
If you want peer reviewed scientific knowledge then you probably should 
run those tests yourself.

I have seen sometimes Sun employees referring on this list to some sort 
of benchmarks for derby.
But I have not found anything public from google.

I think the countless benchmarks published by different database 
companies have proven that
performance is such a complex issue that any type of result can be 
manufactured.
However when done well and extensively they can give some overall 
understanding.

Because H2 has only one developer the code is a bit more straightforward 
and simpler than Derby that has a rich and long history as a codebase.
Therefore I think that H2 is a tad cleaner and faster than Derby in 
basic operation.
Both databases have queries that are very slow.
One could call them bugs.

- rami

On 22.4.2010 19:47, Rayson Ho wrote:
> Is it really true that H2 is faster than Derby??
>
> http://en.wikipedia.org/wiki/Apache_Derby
>
> A year ago, I tried to remove the section that says that H2 is faster,
> but someone always added it back into the article. And besides me,
> seems like no one really care about the "Comparison to other embedded
> SQL Java databases" section.
>
> http://en.wikipedia.org/wiki/Talk:Apache_Derby#Benchmarks
>
> Is it a well-known fact that H2 is always faster??
>
> And there is also H2's benchmark page:
>
> http://www.h2database.com/html/performance.html
>
> Is it a fair comparsion??
>
> Rayson
>