Kalle Korhonen wrote:
Just checking out the new 2.0 enterprise XWiki,
great job! I'm just
wondering why you are using hsqldb in the standalone version rather
than h2 (
http://www.h2database.com/html/main.html). H2 is in pretty
much every way an improved version over hsql and I've been very
impressed with its speed. Have you considered switching over and if
you decided against it, I'd be interested in hearing the reasons. If
you haven't considered it yet, I'll open an issue for it.
This is the first time I hear about it. Looking a bit on its site, I
think that this is a good candidate for replacing hsql as the default
database (Derby is the other one). There is only one problem I can see
with it: choosing the right hibernate dialect. On the H2 documentation,
they warn that the official H2Dialect is buggy (how?), but that the hsql
dialect can be used.
Somebody will have to test it and see if there are any problems, and if
any speed improvement is noticeable.
Please feel free to open an issue, patches welcome :)
One nice feature I spotted: native support for clustering.
--
Sergiu Dumitriu