哪个更好H2或HSQLDB？ [英] Which is better H2 or HSQLDB?

问题描述

HSQLDB 2.0即将发布。我不知道它是否会优于H2，据我所知，大多数用户喜欢H2比HSQLDB。我对HSQLDB 2.0的MVCC支持感兴趣。我已经了解到MVCC在H2上仍然是实验性的。关于支持/文档​​，并发，性能，这两者之间更好？

HSQLDB 2.0 is soon to be released. I wonder if it will outperform H2 since, as far as I know, most users prefer H2 than HSQLDB. I am interested in the MVCC support of HSQLDB 2.0. I have learned that MVCC on H2 is still experimental. With regards to support/documentation, concurrency, performance, which is better between the two?

推荐答案

抽象库（ jOOQ ），它支持这两个数据库。我的130+集成测试涵盖了很多功能，包括调用存储过程和函数，数组，嵌套选择等。我体验到 HSQLDB 2.1 稍快于<

I am the developer of a database abstraction library (jOOQ), which supports both databases. My 130+ integration tests cover a lot of functionality, including the calling of stored procedures and functions, arrays, nested selects, etc. I experience HSQLDB 2.1 to be slightly faster than H2 1.3 for small databases as far as DML is concerned.

但是，HSQLDB在DDL中的表现优于H2操作以及当启动/关闭实例时，即使对于小数据库（由于H2在每次数据库启动时使用javac编译存储的函数）。。这取决于您存储存储函数的方式。显然，这是一个jOOQ特定的问题，另见托马斯·穆勒的评论。

However, HSQLDB highly outperforms H2 in DDL operations as well as when starting/shutting down the instance, even for a small database (due to H2's compiling stored functions afresh with javac at every database startup!). This depends on the way you store stored functions. Apparently, that's a rather jOOQ-specific "issue", see also Thomas Mueller's comment.

另一方面，我同意用户trashgod，合理的模式和使用案例为自己。

On the other hand, I agree with user trashgod, you should test performance against a reasonable schema and use-case for yourself.

这篇关于哪个更好H2或HSQLDB？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！