对H2数据库有什么实际经验吗?[英] Any real world experience with H2 database?

本文是小编为大家收集整理的关于对H2数据库有什么实际经验吗?的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到English标签页查看源文。

问题描述

有没有人在 h2数据库?我对:

  • 性能
  • 稳定性
  • 错误

推荐答案

我们将H2用作非常大的RCP/Eclipse设计工具的存储引擎.该工具本身已经在一些重型项目上使用了2年以上,因此我们对H2的强调非常彻底.

我们对其他可嵌入的DB发动机进行了相当深入的分析,并选择了H2.总的来说,我认为我们对此非常满意.我们的稳定性问题很少,但是正如Zvikico所说,开发团队的反应非常迅速.

虽然性能很好,但有时您需要手工进行一些优化.如果您习惯于使用为您进行很多优化的企业级数据库,那可能会有所改变.如果您遇到慢速查询以查看它在做什么,我建议使用dixply命令.通常,您可以切换加入语句以迫使其更有效地使用索引.

所以,简而言之,我的大拇指!

其他推荐答案

我正在将其用作 nwire ,这是Java的eclipse插件代码探索.它是Java流程的一部分,以嵌入式模式工作,而不是作为服务器.

总体而言,它非常稳定.我已经与H2合作了很长时间:早期我遇到了一些错误,但是现在没有发生这种错误.开发人员的反应也很棒.

关于性能:很好.您可以在网站上看到测试.我没有机会将其与其他工具进行比较,但我对此感到非常满意.在最近的版本中,它确实需要更多时间来打开大型数据库,但是这个问题似乎也得到了解决.

其他一些强调:

  • 非常简单的分发:只有一个罐子.
  • 嵌入式Web控制台对于快速访问数据库非常有用.事实证明这是一种有价值的开发工具.
  • 响应迅速的社区支持,尤其是开发团队的支持.

其他推荐答案

我在一些非常重的服务器应用程序中使用了H2,并带有数百万个记录. H2的性能真是惊人.与往常一样,您需要考虑使用索引.我以前是MySQL的长期用户,并且使用了几个企业级数据库,但是H2比传统的重量级人物更小,更快,更易于使用.它也已成为我们选择的数据库,网址为 tynamo.org

本文地址:https://www.itbaoku.cn/post/597540.html

问题描述

Has anybody out there got any real world experience with the H2 database? I'm interested in:

  • performance
  • stability
  • bugs

推荐答案

We use H2 as the storage engine for a very large RCP/Eclipse-based design tool. The tool itself has been in use for over 2 years now on some data-heavy projects so we've stressed H2 pretty thoroughly.

We did a fairly in-depth analysis of other Java embeddable db engines and chose H2. Overall I think we're pretty happy with it. We've had very few stability issues, but, as zvikico says, the development team is VERY responsive.

While the performance is good, sometimes you need to do some optimizations by hand. If you're used to working with enterprise-level databases that do a lot of this optimization for you, it may be a bit of a change. I'd recommend using the EXPLAIN command if you encounter a slow query to see what it's doing. Very often you can switch around the JOIN statements to force it to use indices more efficiently.

So, in short, thumbs up from me!

其他推荐答案

I'm using it as the base of nWire, which is an Eclipse plugin for Java code exploration. It is working in embedded mode as part of the Java process, not as a server.

Overall, it is very stable. I'm working with H2 for a long time now: I encountered some bugs in the early days, but that hasn't happened in some time now. The response of the developer has been great, too.

Regarding performance: it is very good. You can see the tests on the site. I didn't get a chance to compare it to other tools, but I'm very happy with it. In recent versions, it does tend to take a bit more time to open large databases, but that issue seems to be resolved, too.

Some other strong points:

  • Very simple distribution: just one JAR.
  • The embedded web console is very useful for quick access to the database. It proved to be a valuable development tool.
  • Responsive community support, especially from the development team.

其他推荐答案

I'm using H2 in some pretty heavy server applications with several millions of records. H2's performance is just phenomenal. As always, you need to think through your use of indices though. I was a long time user of MySQL before and have used several enterprise-class databases, but H2 is just smaller, faster and easier to use than the traditional heavyweights. It's also become our database of choice at Tynamo.org