Re: H2 database

Hello and best wishes for this new year.
I have a question concerning the H2 DB.
http://www.h2database.com/html/main.html
I've read (on their site) that they got better perfs than PG or MySQL in
any case (embedded in a Java application and even as a standalone server).
Tests seem a bit "light" with a single thread benchmarking the DB but
the results seem anyway interesting.

However I would be happy to get experts opinion or advice.

Thanks in advance

Pascal

On Tue, Jan 6, 2009 at 1:16 AM, Pascal Cohen <pcohen(at)wimba(dot)com> wrote:
> Hello and best wishes for this new year.
> I have a question concerning the H2 DB.
> http://www.h2database.com/html/main.html
> I've read (on their site) that they got better perfs than PG or MySQL in any
> case (embedded in a Java application and even as a standalone server).
> Tests seem a bit "light" with a single thread benchmarking the DB but the
> results seem anyway interesting.

So, in other words, it's not really that interesting. :) How well a
db runs with a single thread really doesn't mean a lot unless you're
only using it for single user embedded or batch processing. I'd like
to see a simple pgbench style (i.e. mixed reads and writes with
transactions) benchmark with 5, 10, 50, 100 users, etc... That would
tell you something interesting. Since they haven't published a
benchmark with > 1 user, I'm willing to bet that the performance with
> 1 users is not so good, and gets worse as you add users.

http://tweakers.net/reviews/649/8/database-test-sun-ultrasparc-t1-vs-punt-amd-opteron-pagina-8.html

Now that is an interesting benchmark. Notice how MySQL is a good
20-30% faster with one user? More importantly see what it does with
many users, and how it behaves as the number of users increases.

2009/1/6 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
> On Tue, Jan 6, 2009 at 1:16 AM, Pascal Cohen <pcohen(at)wimba(dot)com> wrote:
>> Hello and best wishes for this new year.
>> I have a question concerning the H2 DB.
>> http://www.h2database.com/html/main.html
>> I've read (on their site) that they got better perfs than PG or MySQL in any
>> case (embedded in a Java application and even as a standalone server).
>> Tests seem a bit "light" with a single thread benchmarking the DB but the
>> results seem anyway interesting.
>

I see many benchs that say a *database is better than the most popular
(velneo,h2,
db4, etc). But if all of the benchs was 100% really the most popular
was disapear too
many year ago :)

> So, in other words, it's not really that interesting. :) How well a
> db runs with a single thread really doesn't mean a lot unless you're
> only using it for single user embedded or batch processing. I'd like
> to see a simple pgbench style (i.e. mixed reads and writes with
> transactions) benchmark with 5, 10, 50, 100 users, etc... That would
> tell you something interesting. Since they haven't published a
> benchmark with > 1 user, I'm willing to bet that the performance with
>> 1 users is not so good, and gets worse as you add users.
>
> http://tweakers.net/reviews/649/8/database-test-sun-ultrasparc-t1-vs-punt-amd-opteron-pagina-8.html

It's really interesting link.

In adding, not so only 1 user. What happends if these user make more
complex works...
i don't know what's the behavior that could get mysql in front
postgres or others.

>
> Now that is an interesting benchmark. Notice how MySQL is a good
> 20-30% faster with one user? More importantly see what it does with
> many users, and how it behaves as the number of users increases.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Emanuel Calvo Franco
Syscope Postgresql Consultant
ArPUG / AOSUG Member