任何真实世界的H2数据库经验？ [英] Any real world experience with H2 database?

问题描述

有任何人使用 H2数据库获得任何真实世界的体验吗？我感兴趣的是：

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

• 性能


• 稳定性


• bugs

推荐答案

我们使用H2作为非常大的RCP / Eclipse的存储引擎的设计工具。该工具本身已经使用了2年以上的一些数据重的项目，所以我们强调H2很彻底。

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.

我们对其他Java可嵌入数据库引擎进行了相当深入的分析，并选择了H2。总的来说，我认为我们很高兴。我们有很少的稳定性问题，但是，正如zvikico所说，开发团队是非常响应。

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.

虽然性能很好，有时你需要做一些优化用手。如果你习惯于使用企业级数据库，为你做很多这种优化，它可能有点改变。我建议使用EXPLAIN命令，如果你遇到一个慢查询，看看它在做什么。很多时候你可以切换JOIN语句，使它更有效地使用索引。

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!

这篇关于任何真实世界的H2数据库经验？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！