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 :) -- Sergiu Dumitriu http://purl.org/net/sergiu/