entityMap|blocks|key|2a6bb|text|尝试下面的代码，它在Hibernate和其他ORM框架中表现得非常好|type|unstyled|depth|inlineStyleRanges|entityRanges|data|o7co|http://hsqldb.org/^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

Try the following, it performs really well with Hibernate and other ORM frameworks

<a href="http://hsqldb.org/" rel="nofollow noreferrer">http://hsqldb.org/</a>

entityMap|blocks|key|32e0f|text|如果您希望将所有数据存储在内存中，您可能需要查看|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7vjok|Prevayler|d0259|..。|3tctj|我自己从来没有用过它，但对于所有数据都可以存储在内存中的情况，它似乎是一个比使用关系数据库更好的解决方案。^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|I|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|J|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|K|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|L|9|@]|A|@]|B|$]]]]

If you want to store all of your data in memory, you might want to look at <a href="http://www.prevayler.org/wiki/" rel="nofollow noreferrer">Prevayler</a>.

I've never used it myself, but it seems like a much better solution than using a relational database for those cases in which all of your data can be stored in memory.

entityMap|blocks|key|7tggn|text|我不知道这是不是最快的选择，但我对此非常满意|type|unstyled|depth|inlineStyleRanges|entityRanges|data|eapei|H2|flsb5|只要我用过它。它是由最初编写Hypersonic+(后来成为HSQLDB)的同一个人编写的。|bm8nh|另一个据称非常快的选择是|9b6ck|Prevayler|4peht|..。^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|N|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|O|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|P|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|Q|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|R|9|@]|A|@]|B|$]]]]

I don't know if it is the fastest option, but I've been very satisfied with <a href="http://www.h2database.com/html/main.html" rel="noreferrer">H2</a> whenever I've used it. It's written by the same person who originally wrote Hypersonic (which later became HSQLDB).

Another option that is allegedly very fast is <a href="http://www.prevayler.org/" rel="noreferrer">Prevayler</a>.

entityMap|blocks|key|aafbp|text|你可以尝试像这样的东西|type|unstyled|depth|inlineStyleRanges|entityRanges|data|d978u|Prevayler|3md64|(基本上是一个内存中的缓存，它为您处理序列化和备份，因此数据可以持久保存，并且在事务上是安全的)。还有其他类似的项目。我已经在一个大型项目中使用过它，它很安全，而且速度非常快。|ef0j7|如果是同一组20,000个对象，或者至少不是每5秒有20,000个新对象，而是有很多更改，那么您最好缓存这些更改并定期以批处理模式写入这些更改(jdbc批处理更新比单个行更新快得多)。这取决于您是否需要对每个写入进行事务性包装，以及您是否需要更改日志的记录或仅聚合更改。|evvaj|编辑|21l5f|：就像其他文章提到的Prevayler一样，我想我应该对它的作用留下一个注释:基本上你创建了一个可搜索/可序列化的对象(通常是某种类型的Map+)，它被包装在Prevayler实例中，该实例被序列化到磁盘上。您可以通过向Prevayler实例发送更改的可序列化记录(只是一个包含更改指令的对象)来进行更改，而不是直接对地图进行更改。Prevayler的事务版本是将您的序列化更改写入磁盘，以便在失败的情况下，它可以加载最后一个完整的备份，然后根据该备份重放更改。它是安全的，尽管您必须有足够的内存来加载所有数据，而且它是一个相当旧的API，所以不幸的是没有通用接口。但绝对是稳定的，工作起来就像广告所说的那样。^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|N|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|O|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|P|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|Q|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|R|9|@]|A|@]|B|$]]]]

You could try something like <a href="http://prevayler.org/old_wiki/Welcome.html" rel="noreferrer">Prevayler</a> (basically an in-memory cache that handles serialization and backup for you so data persists and is transactionally safe). There are other similar projects.
I've used it for a large project, it's safe and extremely fast.

If it's the same set of 20,000 objects, or at least not 20,000 new objects every 5 seconds but lots of changes, you might be better off cacheing the changes and periodically writing the changes in batch mode (jdbc batch updates are much faster than individual row updates). Depends on whether you need each write to be transactionally wrapped, and whether you'll need a record of the change logs or just aggregate changes. 

Edit: as other posts have mentioned Prevayler I thought I'd leave a note on what it does: 
Basically you create a searchable/serializable object (typically a Map of some sort) which is wrapped in a Prevayler instance, which is serialized to disk. Rather than making changes directly to your map, you make changes by sending your Prevayler instance a serializable record of your change (just an object that contains the change instruction). Prevayler's version of a transaction is to write your serialization changes to disk so that in the event of failure it can load the last complete backup and then replay the changes against that. It's safe, although you do have to have enough memory to load all of your data, and it's a fairly old API, so no generic interfaces, unfortunately. But definitely stable and works as advertised.

entityMap|blocks|key|7rgij|text|hsqldb相当快，但它不是ACID事务安全的。我所知道的最快的java数据库是db4o：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|24av7|基准测试|94l89|..。|9l1vu|编辑|enei1|：请注意，Prevayler不是数据库，请参阅|62s26|http://www.prevayler.org/wiki.jsp?topic=PrevaylerIsNotADatabase|3rqtk|..。如果内存用完了，那你就不走运了。^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|O|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|P|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|Q|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|R|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|S|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|T|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|U|9|@]|A|@]|B|$]]]]

hsqldb is quite fast, but it is not ACID transaction-safe. The fastest java-database I know is db4o: <a href="http://www.db4o.com/about/productinformation/benchmarks/" rel="nofollow noreferrer">benchmarks</a>.

Edit: Please notice that Prevayler is not a database, see <a href="http://www.prevayler.org/wiki.jsp?topic=PrevaylerIsNotADatabase" rel="nofollow noreferrer">http://www.prevayler.org/wiki.jsp?topic=PrevaylerIsNotADatabase</a>. If you're out of RAM, you're out of luck.

entityMap|blocks|key|3t331|text|Berkeley+DB+for+Java|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4k2fm|是一个快速的内存数据库，对于简单的对象图非常有用。^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

<a href="http://www.oracle.com/technology/products/berkeley-db/index.html" rel="nofollow noreferrer">Berkeley DB for Java</a> is a fast in memory database, extremely useful for simple object graphs.

entityMap|blocks|key|3o777|text|陶土也可能是你的答案。它允许多个虚拟机共享对象，因此您可以分布负载等。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

Terracotta might also be an answer for you. It allows multiple VMs to share objects so you can distribute load etc...

entityMap|blocks|key|7js4q|text|我强烈推荐|type|unstyled|depth|inlineStyleRanges|entityRanges|data|ave0r|H2|crotn|..。这是HSQLDB的“第二代”版本，由原作者之一完成。|brjge|fe8aj|允许我们在不需要实际PostgreSQL数据库的情况下对DAO层进行单元测试，这是|75fr2|太棒了|200r8|..。|fl1j0|有一个活跃的网群和邮件列表，作者Thomas+Mueller对查询非常敏感(哈哈，这是个小双关语)。^0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|P|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|Q|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|R|9|@]|A|@]|B|$]]|$2|G|4|D|6|7|8|S|9|@]|A|@]|B|$]]|$2|H|4|I|6|7|8|T|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|U|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|V|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|W|9|@]|A|@]|B|$]]]]

I highly recommend <a href="http://www.h2database.com/html/main.html" rel="noreferrer">H2</a>. This is a kind of "second generation" version of HSQLDB done by one of the original authors. H2 allows us to unit-test our DAO layer without requiring an actual PostgreSQL database, which is awesome.

There is an active net group and mailing list, and the author Thomas Mueller is very responsive to queries (hah, little pun there.)

entityMap|blocks|key|9g1o4|text|你可以试试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|efgk2|CSQL|cpqv3|(在开源和企业版下可用)它提供30倍于基于磁盘的数据库系统的性能改进，并提供JDBC接口。它可以配置为独立的内存数据库，也可以作为MySQL、Postgres、Oracle数据库的透明缓存。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|H|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|I|9|@]|A|@]|B|$]]]]

You can try <a href="http://www.csqldb.com" rel="nofollow noreferrer">CSQL</a> (available under open source and enterprise version) It provides 30X performance improvement over disk based database systems and provides JDBC interface. It can be configured to work as stand alone main memory database or as a transparent cache to MySQL, Postgres, Oracle databases.

entityMap|blocks|key|8icr|text|您还可以查看|type|unstyled|depth|inlineStyleRanges|entityRanges|data|avdj6|db4o^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

You can also check out <a href="http://www.db4o.com/" rel="nofollow noreferrer">db4o</a>

entityMap|blocks|key|a9d9q|text|H2真的很棒，实际上，在内存、普通服务器和事务方面，您拥有一切。然而，它在性能上无法与对象数据库相比，我看到Db4o提到过，事实上，我使用Neodatis的性能要好得多，并且在Maven存储库中设置得很好。虽然不是很健壮，但像法拉利一样快，但不像甲骨文那样是卡车。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

H2 is truly fantastic, indeed, in memory, normal server and transactional, you have it all. However It doesn't compare in performance to the object databases, I see Db4o mentioned, I have had much better performance with Neodatis in fact, and everything nicely set up in Maven repositories. Although not very robust, like a Ferrari, fast but not a truck like Oracle.

entityMap|blocks|key|4hcbq|text|我会试一试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|je62|OrientDB|b6ea7|..。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|H|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|I|9|@]|A|@]|B|$]]]]

I would give a try to <a href="http://www.orientechnologies.com/" rel="nofollow">OrientDB</a>.

entityMap|blocks|key|81dra|text|这是一个有点老的问题，但是现在有很多数据库的性能级别达到了20,000/s。选择哪个数据库取决于您想要进行的查询的数据结构和类型。它还取决于总体音量。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|dfcru|对于大量的时间序列数据，我们也遇到了类似的问题，大约有300,000个记录/秒，我们最终编写了一个新的数据库，具有足够简单的API和良好的性能。它可以进行大约2,000,000次对象写入/秒，我们没有使用ORM。|5b8rp|它后来演变成|46lpe|QuestDB|52lvr|..。^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|K|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|L|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|M|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|N|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|O|9|@]|A|@]|B|$]]]]

It is a bit of an old question, but these days there is a whole lot of databases that have a level of performance of 20,000/s. Which database to chose depends on data structure and type of queries you'd like to be making. It also depends on overall volume.
We had similar problem with large volume of time series data, about 300,000 rec/s and we ended up writing a new database, with simple enough API and decent performance. It can do about 2,000,000 object writes/s and we did away without ORM.
It later evolved into <a href="https://questdb.io/" rel="nofollow noreferrer">QuestDB</a>.

entityMap|blocks|key|d7que|text|编年史地图|type|unstyled|depth|inlineStyleRanges|entityRanges|data|dcvni|是一个可嵌入的纯Java持久化数据库，提供了一个简单的|4ajsi|接口。它可以承受大约|2lvo3|100万|14ls6|每秒查询/更新次数|1htl6|从单个线程|9j2bn|，一致的读/写性能，并几乎线性地扩展到机器中的核心数量。|19sgn|以下是一些具有实际数字的最新性能研究：|8pic5|Jetbrains+Xodus、Oracle+Berkeley+DB+JE+BTree、MapDB+TreeMap、编年史地图和H2+MVStore地图的比较|91ded|LmdbJava基准测试^0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|U|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|V|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|W|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|X|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|Y|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|Z|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|10|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|11|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|12|9|@]|A|@]|B|$]]|$2|S|4|T|6|7|8|13|9|@]|A|@]|B|$]]]]

<a href="https://github.com/OpenHFT/Chronicle-Map" rel="nofollow noreferrer">Chronicle Map</a> is an embeddable pure Java persistent database, providing a simple <code>java.util.Map</code> interface. It withstands about 1 million queries/updates per second from a single thread, consistent read/write performance and scales almost linearly to the number of cores in the machine.

Here are some recent performance research with actual numbers:

<ul>
<li><a href="http://jetbrains.github.io/xodus/#benchmarks" rel="nofollow noreferrer">Comparison of Jetbrains Xodus, Oracle Berkeley DB JE BTree, MapDB TreeMap, Chronicle Map and H2 MVStore Map</a></li>
<li><a href="https://github.com/lmdbjava/benchmarks" rel="nofollow noreferrer">LmdbJava Benchmarks</a></li>
</ul>

I need ideas to implement a (really) high performance in-memory Database/Storage Mechanism in Java. In the range of storing 20,000+ java objects, updated every 5 or so seconds. 
Some options I am open to:

Pure JDBC/database combination

JDO

JPA/ORM/database combination

An Object Database

Other Storage Mechanisms

What is my best option? What are your experiences?

EDIT: I also need like to be able to Query these objects

Highest Performance Database in Java

 我需要一些想法来在Java中实现一个(真的)高性能的内存中数据库/存储机制。在存储20,000+ java对象的范围内，每5秒左右更新一次。 以下是我可以选择的一些选项： 纯JDBC/数据库组合 JDO JPA/ORM/数据库组合 对象数据库 其他存储机制 我最好的选择是什么？你有什么经验？ 编辑:我还需要能够查询这...

问Java中最高性能的数据库
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Java中最高性能的数据库EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Java中最高性能的数据库
EN