Also, if you decide that the DB doesn't absolutely need to be in-memory, it just needs to be fast, you might want to consider CouchDB. It can do continuous replication, which is essentially instant, and all nodes are masters. It has a well-thought-out conflict detection and resolution mechanism. This blog post is a great introduction to the latest and greatest CouchDB replication capabilities.
Though there is no replication support built-in, you can use triggers with an in-memory SQLite database. Within the trigger, use a custom function to communicate the changes to the other sites.
You might want to check out Altibase. They said they have the world's fastest in-memory database. They say they are 5 to 10 times faster than most in-memory DBMS and they also have a free trial on the site.
I obviously compare Derby, SQLite and HSQLDB. Oracle isn't a in memory db. But I put it's result to table because to show speed difference between a in memory db and normal db.
PS: In SQLite and HSQLDB result aren't stable. So I choose 10 stable results in 100 try. Sometimes HSQLDB is faster than SQLite. I think theirs performance are same.
发布评论
评论（4）
查看 Redis。这是复制方法。
另外，如果您认为数据库并不绝对需要位于内存中，它只需要速度快，您可能需要考虑 CouchDB。它可以做连续复制，本质上是即时的，所有节点都是master。它有一个经过深思熟虑的冲突检测和解决机制。 这篇博文< /a> 是对最新、最强大的 CouchDB 复制功能的精彩介绍。
Check out Redis. Here's the Replication Howto.
Also, if you decide that the DB doesn't absolutely need to be in-memory, it just needs to be fast, you might want to consider CouchDB. It can do continuous replication, which is essentially instant, and all nodes are masters. It has a well-thought-out conflict detection and resolution mechanism. This blog post is a great introduction to the latest and greatest CouchDB replication capabilities.
尽管没有内置的复制支持，但您可以将 触发器 与内存中 < href="http://www.sqlite.org" rel="nofollow noreferrer">SQLite 数据库。在触发器内，使用自定义函数将更改传达给其他站点。
Though there is no replication support built-in, you can use triggers with an in-memory SQLite database. Within the trigger, use a custom function to communicate the changes to the other sites.
您可能想查看 Altibase。他们说他们拥有世界上最快的内存数据库。他们表示，它们比大多数内存 DBMS 快 5 到 10 倍，并且在网站上提供免费试用。
You might want to check out Altibase. They said they have the world's fastest in-memory database. They say they are 5 to 10 times faster than most in-memory DBMS and they also have a free trial on the site.
我在 Websphere Server 中执行了包含 6000 多行的复杂 SQL 10000 次。总净执行时间如下：
我显然比较了 Derby、SQLite 和 HSQLDB。 Oracle 不是内存数据库。但我将其结果放入表中，因为要显示内存数据库和普通数据库之间的速度差异。
PS：在 SQLite 和 HSQLDB 中结果不稳定。所以我在100次尝试中选择10个稳定的结果。有时 HSQLDB 比 SQLite 更快。我认为他们的表现是一样的。
I execute a complex SQL which has more than 6000 rows 10000 times in my Websphere Server. Total net execution times are like that:
I obviously compare Derby, SQLite and HSQLDB. Oracle isn't a in memory db. But I put it's result to table because to show speed difference between a in memory db and normal db.
PS: In SQLite and HSQLDB result aren't stable. So I choose 10 stable results in 100 try. Sometimes HSQLDB is faster than SQLite. I think theirs performance are same.