I got curious when you mentioned H2 (hadn't heard about it before), so I took a quick look at its home page. The first impression is that it is quite different from Firebird. The most important difference I noticed (from my viewpoint) is that they state that table level locks are a feature of H2, whereas for my Firebird use, table level locks would be a show stopper. H2 supports multi-version concurrency control (MVCC) as an additional feature (in Firebird, MVCC is fundamental), but they state it isn't fully tested yet and also mention a few drawbacks of their implementation.

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Codebue Fabio - P-Soft
Sent: 21. mai 2010 06:40
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Difference from H2 and firebird

Someone can explain in depth difference from H2 and firebird?

H2 PRO

* Is java based
* Develeopment say it is very very fast
* Easy to install, configure and use with java application

H2 CONS

* Is a young project
* Reliability doubt for commercial porpouse

FireBird PRO

* Rock solid project
* Well documented
* Should be fast and well optimized for large data
* Has a java driver...

FireBird CONS

* It is not java based


Codebue Fabio