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 results aren't stable. So I choosed 10 stable results in 100 tries. Sometimes HSQLDB is faster than SQLite. I think theirs performance are same.
发布评论
评论（2）
有完整的比较 SQLite 网站。
SQLite 受到更多限制，因为它仅支持 SQL92 的一小部分，而 Derby（现在的 JavaDB）则完全支持 SQL92 和 SQL99。
There's a full comparison at SQLite's site.
SQLite is much more restricted, as it only supports a small subset of SQL92, whereas Derby (now JavaDB) has full support of SQL92 and SQL99.
我在 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 results aren't stable. So I choosed 10 stable results in 100 tries. Sometimes HSQLDB is faster than SQLite. I think theirs performance are same.